/* GL AUTOPOST DEFINITIONS 
Written by Daniel North,  ORAFINAPPS Limited 2007
Lists the autopost definitions by book show the journal source and category
Tested on Vision 11.5.10.2  June 2007 */
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