Purchasing period table in oracle r12

Purchasing period table in oracle r12

In this post , We will be discuss about Purchasing period table in oracle r12. This table will help to store the Purchasing period informations in oracle r12. Purchasing period table helps to store all detail about Purchase order details in oracle r12. We will be share the sql query to extract the purchasing period informations and complete table list of Purchasing period table in oracle. Here below is the complete detail about Purchasing period table in oracle r12. 

Purchasing period table in oracle r12

2 Important Purchasing period table in oracle r12

1.gl_period_statuses

2.GL_SETS_OF_BOOKS

SQL Query used by Purchasing period table in oracle r12

SELECT sob.name "Set of Books" ,

  ps.PERIOD_NAME "Period Name" ,

  ps.START_DATE "Period Start Date" ,

  ps.END_DATE "Period End Date" ,

  DECODE(ps.closing_status, 'O','O - Open' ,

                            'N','N - Never Opened' ,

                            'F','F - Future Enterable' ,

                            'C','C - Closed' ,'Unknown') "Period Status"

FROM gl_period_statuses ps ,

  GL_SETS_OF_BOOKS sob ,

  FND_APPLICATION_VL fnd

WHERE ps.application_id  ='201' --PO

AND sob.SET_OF_BOOKS_ID       = ps.SET_OF_BOOKS_ID

AND fnd.application_id        = ps.application_id

AND ps.adjustment_period_flag = 'N'

AND (TRUNC(SYSDATE) BETWEEN TRUNC(ps.start_date) AND TRUNC (ps.end_date))

ORDER BY ps.SET_OF_BOOKS_ID,

  ps.start_date

Purchasing period table in oracle r12