Product: | AX - Global Accounting Engine |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT P.ROWID ROW_ID
, P.APPLICATION_ID
, A.APPLICATION_NAME
, P.MAIN_SET_OF_BOOKS_ID
, S1.NAME MAIN_SET_OF_BOOKS
, P.POSTING_SET_OF_BOOKS_ID
, S2.NAME POSTING_SET_OF_BOOKS
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, P.REQUEST_ID
, P.PROGRAM_APPLICATION_ID
, P.PROGRAM_ID
, P.PROGRAM_UPDATE_DATE
, P.FROZEN_FLAG
, P.RULE_NAME
, P.FROZEN_DATE
FROM AX_TRANS_PROGRAMS P
, GL_SETS_OF_BOOKS S1
, GL_SETS_OF_BOOKS S2
, FND_APPLICATION_VL A
WHERE P.POSTING_SET_OF_BOOKS_ID = S2.SET_OF_BOOKS_ID
AND P.MAIN_SET_OF_BOOKS_ID = S1.SET_OF_BOOKS_ID
AND P.APPLICATION_ID = A.APPLICATION_ID