View: PA_GL_SET_OF_BOOKS_V

Product:	PA - Projects
Description:	This view is being used in forms, reports, and concurrent processes to get the primary currency and reporting currency given above attributes for the implemented OU.
Implementation/DBA Data:	APPS.PA_GL_SET_OF_BOOKS_V

View Text

SELECT SOB.NAME SET_OF_BOOKS_NAME
, SOB.CURRENCY_CODE CURRENCY
, SUBSTRB(LKP.MEANING
, 1
, 30) SET_OF_BOOKS_TYPE
, LKP.LOOKUP_CODE SET_OF_BOOKS_TYPE_CODE
, IMP.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, IMP.ORG_ID ORG_ID
FROM GL_SETS_OF_BOOKS SOB
, PA_IMPLEMENTATIONS IMP
, GL_LOOKUPS LKP
WHERE SOB.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID
AND LKP.LOOKUP_TYPE = 'MRC_SOB_TYPE'
AND LKP.LOOKUP_CODE = 'P' UNION ALL SELECT SOB.NAME SET_OF_BOOKS_NAME
, GAL.CURRENCY_CODE CURRENCY
, SUBSTRB(LKP.MEANING
, 1
, 30) SET_OF_BOOKS_TYPE
, LKP.LOOKUP_CODE SET_OF_BOOKS_TYPE_CODE
, GAL.LEDGER_ID SET_OF_BOOKS_ID
, IMP.ORG_ID ORG_ID
FROM GL_ALC_LEDGER_RSHIPS_V GAL
, GL_SETS_OF_BOOKS SOB
, PA_IMPLEMENTATIONS IMP
, GL_LOOKUPS LKP
WHERE GAL.SOURCE_LEDGER_ID = IMP.SET_OF_BOOKS_ID
AND SOB.SET_OF_BOOKS_ID = GAL.LEDGER_ID
AND GAL.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND (GAL.ORG_ID = -99 OR GAL.ORG_ID = IMP.ORG_ID)
AND GAL.APPLICATION_ID = 275
AND LKP.LOOKUP_TYPE = 'MRC_SOB_TYPE'
AND LKP.LOOKUP_CODE = 'R'

Columns