View: PA_CROSS_CHARGEABLE_OU_BASE_V

Product:	PA - Projects
Description:	View of operating units that are Cross chargeable from the current operating unit
Implementation/DBA Data:	APPS.PA_CROSS_CHARGEABLE_OU_BASE_V

View Text

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'

Columns