VIEW: APPS.PA_GL_SET_OF_BOOKS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'