Autopost Definitions

GL AUTOPOST DEFINITIONS

-----------------------------------

The Following query will list the autopost definitions by book show the journal source and category.

I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.

I have commented the SOB condition. Check your Instances SOB short-name and provide accordingly if you have multiple SOB in your business Structure.

SELECT SOB.NAME "BOOK"
, APS.AUTOPOST_SET_NAME "SET NAME"
, APS.DESCRIPTION
, APS.ENABLED_FLAG
, APS.SUBMIT_ALL_PRIORITIES_FLAG "SUBMIT ALL?"
, APO.ACTUAL_FLAG "ACTUAL FLAG"
, APO.PERIOD_NAME "PERIOD"
, APO.JE_SOURCE_NAME "SOURCE"
, APO.USER_JE_CATEGORY_NAME "CATEGORY"
FROM GL_AUTOMATIC_POSTING_SETS_V APS, GL_AUTOMATIC_POSTING_OPTIONS_V APO, GL_SETS_OF_BOOKS SOB
WHERE APO.AUTOPOST_SET_ID = APS.AUTOPOST_SET_ID
AND APS.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
--AND SUBSTR(SOB.NAME,1,2) IN ('HB')
ORDER BY 1