Thursday, November 17, 2011

GL AUTOPOST DEFINITIONS

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 ('ES','LU','BE')
ORDER BY 1

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect