[Home] [Help]
View: AX_ORGS_SOBS_V
Product: | AX - Global Accounting Engine |
Description: | SOBs and Orgs relationships in subledger applications |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 200 APPLICATION_ID
, ASPA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GSOB.SHORT_NAME SET_OF_BOOKS_NAME
, ASPA.ORG_ID ORG_ID
FROM GL_SETS_OF_BOOKS GSOB
, AP_SYSTEM_PARAMETERS_ALL ASPA
WHERE ASPA.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID UNION SELECT 222 APPLICATION_ID
, ARSPA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GSOB.SHORT_NAME SET_OF_BOOKS_NAME
, ARSPA.ORG_ID ORG_ID
FROM GL_SETS_OF_BOOKS GSOB
, AR_SYSTEM_PARAMETERS_ALL ARSPA
WHERE ARSPA.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID UNION SELECT 401 APPLICATION_ID
, OOD.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GSOB.SHORT_NAME SET_OF_BOOKS_NAME
, OOD.ORGANIZATION_ID ORG_ID
FROM GL_SETS_OF_BOOKS GSOB
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE OOD.SET_OF_BOOKS_ID=GSOB.SET_OF_BOOKS_ID
Columns
Name |
APPLICATION_ID |
SET_OF_BOOKS_ID |
SET_OF_BOOKS_NAME |
ORG_ID |