Product: | AX - Global Accounting Engine |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PB.ROWID
, PB.APPLICATION_ID
, A.APPLICATION_NAME
, PB.MAIN_SET_OF_BOOKS_ID
, SOB1.NAME
, PB.SOURCE_ORG_ID
, OU.NAME
, PB.POSTING_SET_OF_BOOKS_ID
, SOB2.NAME
, PB.LAST_UPDATE_DATE
, PB.LAST_UPDATED_BY
, PB.CREATION_DATE
, PB.CREATED_BY
, PB.LAST_UPDATE_LOGIN
, PB.REQUEST_ID
, PB.PROGRAM_APPLICATION_ID
, PB.PROGRAM_ID
, PB.PROGRAM_UPDATE_DATE
, PB.RULE_NAME
, PB.TRANSFER_TO_GL
, PB.JE_LINE_TYPE
, PB.EZL_REQUIRED
, PB.ERROR_TO_SUSPENSE_ACCNT
, PB.GL_POST_REQUIRED
, PB.RULE_CHANGED_FLAG
FROM GL_SETS_OF_BOOKS SOB2
, HR_OPERATING_UNITS OU
, GL_SETS_OF_BOOKS SOB1
, FND_APPLICATION_VL A
, AX_SETUP_POSTING_BOOKS PB
WHERE PB.SOURCE_ORG_ID <> 0
AND A.APPLICATION_ID = PB.APPLICATION_ID
AND SOB1.SET_OF_BOOKS_ID = PB.MAIN_SET_OF_BOOKS_ID
AND SOB2.SET_OF_BOOKS_ID = PB.POSTING_SET_OF_BOOKS_ID
AND OU.ORGANIZATION_ID = PB.SOURCE_ORG_ID UNION SELECT PB.ROWID
, PB.APPLICATION_ID
, A.APPLICATION_NAME
, PB.MAIN_SET_OF_BOOKS_ID
, SOB1.NAME
, PB.SOURCE_ORG_ID
, L.MEANING
, PB.POSTING_SET_OF_BOOKS_ID
, SOB2.NAME
, PB.LAST_UPDATE_DATE
, PB.LAST_UPDATED_BY
, PB.CREATION_DATE
, PB.CREATED_BY
, PB.LAST_UPDATE_LOGIN
, PB.REQUEST_ID
, PB.PROGRAM_APPLICATION_ID
, PB.PROGRAM_ID
, PB.PROGRAM_UPDATE_DATE
, PB.RULE_NAME
, PB.TRANSFER_TO_GL
, PB.JE_LINE_TYPE
, PB.EZL_REQUIRED
, PB.ERROR_TO_SUSPENSE_ACCNT
, PB.GL_POST_REQUIRED
, PB.RULE_CHANGED_FLAG
FROM GL_SETS_OF_BOOKS SOB2
, GL_SETS_OF_BOOKS SOB1
, FND_APPLICATION_VL A
, AX_LOOKUPS L
, AX_SETUP_POSTING_BOOKS PB
WHERE PB.SOURCE_ORG_ID = 0
AND A.APPLICATION_ID = PB.APPLICATION_ID
AND SOB1.SET_OF_BOOKS_ID = PB.MAIN_SET_OF_BOOKS_ID
AND SOB2.SET_OF_BOOKS_ID = PB.POSTING_SET_OF_BOOKS_ID
AND L.LOOKUP_CODE = 'ALL_OPERATING_UNITS'
AND L.LOOKUP_TYPE = 'AX_FIXED_OPERATING_UNITS'