VIEW: APPS.PA_CROSS_CHARGEABLE_OU_BASE_V

Source

View Text - Preformatted

SELECT imp.org_id ,iall.org_id ,imp.business_group_id ,iall.business_group_id ,iall.set_of_books_id ,iall.pa_period_type ,nvl(ple.ORG_INFORMATION2, '-99') ,nvl(rle.ORG_INFORMATION2,' -99') ,iall.PROJ_ORG_STRUCTURE_VERSION_ID ,iall.PROJ_ORG_STRUCTURE_ID ,iall.PROJ_START_ORG_ID ,iall.EXP_ORG_STRUCTURE_VERSION_ID ,iall.EXP_ORG_STRUCTURE_ID ,iall.EXP_START_ORG_ID ,iall.ORG_STRUCTURE_VERSION_ID ,iall.ORGANIZATION_STRUCTURE_ID ,iall.START_ORGANIZATION_ID ,imp.cc_allow_iu_flag ,iall.cc_allow_iu_flag FROM HR_ORGANIZATION_INFORMATION ple, HR_ORGANIZATION_INFORMATION rle, pa_implementations imp, pa_implementations_all iall WHERE ((imp.business_group_id = iall.business_group_id and pa_cross_business_grp.IsCrossBGProfile='N') OR pa_cross_business_grp.IsCrossBGProfile='Y') AND ple.organization_id(+) = imp.org_id AND ple.ORG_INFORMATION_CONTEXT(+) = 'Operating Unit Information' AND rle.organization_id(+) = iall.org_id AND rle.ORG_INFORMATION_CONTEXT(+) = 'Operating Unit Information'

View Text - HTML Formatted

SELECT IMP.ORG_ID
, IALL.ORG_ID
, IMP.BUSINESS_GROUP_ID
, IALL.BUSINESS_GROUP_ID
, IALL.SET_OF_BOOKS_ID
, IALL.PA_PERIOD_TYPE
, NVL(PLE.ORG_INFORMATION2
, '-99')
, NVL(RLE.ORG_INFORMATION2
, ' -99')
, IALL.PROJ_ORG_STRUCTURE_VERSION_ID
, IALL.PROJ_ORG_STRUCTURE_ID
, IALL.PROJ_START_ORG_ID
, IALL.EXP_ORG_STRUCTURE_VERSION_ID
, IALL.EXP_ORG_STRUCTURE_ID
, IALL.EXP_START_ORG_ID
, IALL.ORG_STRUCTURE_VERSION_ID
, IALL.ORGANIZATION_STRUCTURE_ID
, IALL.START_ORGANIZATION_ID
, IMP.CC_ALLOW_IU_FLAG
, IALL.CC_ALLOW_IU_FLAG
FROM HR_ORGANIZATION_INFORMATION PLE
, HR_ORGANIZATION_INFORMATION RLE
, PA_IMPLEMENTATIONS IMP
, PA_IMPLEMENTATIONS_ALL IALL
WHERE ((IMP.BUSINESS_GROUP_ID = IALL.BUSINESS_GROUP_ID
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='Y')
AND PLE.ORGANIZATION_ID(+) = IMP.ORG_ID
AND PLE.ORG_INFORMATION_CONTEXT(+) = 'OPERATING UNIT INFORMATION'
AND RLE.ORGANIZATION_ID(+) = IALL.ORG_ID
AND RLE.ORG_INFORMATION_CONTEXT(+) = 'OPERATING UNIT INFORMATION'