Oracle fa period status query

Oracle fa period status query

In this post , We will be discuss about Oracle fa period status query. This query will help to extract the FA period details including period status in oracle apps. FA period status means , to know whether fa period is 'Open' or 'closed'. Using Period status , we can know the fa period detail status. Here below i will share the complete sql query about fa period status. Please find below the detail about Oracle fa period status query.

Important table used by Oracle fa period status query

1.fa_book_controls

2.fa_deprn_periods

Detail sql Query to extract Oracle fa period status.

SELECT fdp.period_name,

            DECODE (fdp.period_close_date,

            NULL,'Open','Closed') fa_status

          ,fbc.set_of_books_id

    FROM fa_book_controls fbc

        ,fa_deprn_periods fdp

    WHERE fbc.set_of_books_id = :P_SOB_ID

    AND fbc.book_type_code = fdp.book_type_code

    AND UPPER (fdp.period_name) = UPPER (:PERIOD_NAME)