View: PA_CROSS_CHARGEABLE_OU_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_V

View Text

SELECT PCOUB.PRVDR_ORG_ID
, PCOUB.RECVR_ORG_ID
, PCOUB.BUSINESS_GROUP_ID
, PCOUB.RECVR_BUSINESS_GROUP_ID
, PCOUB.SET_OF_BOOKS_ID
, PCOUB.PA_PERIOD_TYPE
, PCOUB.PRVDR_LEGAL_ENTITY_ID
, PCOUB.RECVR_LEGAL_ENTITY_ID
, PCOUB.PROJ_ORG_STRUCTURE_VERSION_ID
, PCOUB.PROJ_ORG_STRUCTURE_ID
, PCOUB.PROJ_START_ORG_ID
, PCOUB.EXP_ORG_STRUCTURE_VERSION_ID
, PCOUB.EXP_ORG_STRUCTURE_ID
, PCOUB.EXP_START_ORG_ID
, PCOUB.ORG_STRUCTURE_VERSION_ID
, PCOUB.ORGANIZATION_STRUCTURE_ID
, PCOUB.START_ORGANIZATION_ID
FROM PA_CC_ORG_RELATIONSHIPS CO
, PA_CROSS_CHARGEABLE_OU_BASE_V PCOUB
WHERE CO.PRVDR_ORG_ID (+) = PCOUB.PRVDR_ORG_ID
AND CO.RECVR_ORG_ID (+) = PCOUB.RECVR_ORG_ID
AND ((NVL(PCOUB.PRVDR_ORG_ID
, -99) = NVL(PCOUB.RECVR_ORG_ID
, -99)) OR ( PCOUB.PRVDR_LEGAL_ENTITY_ID = PCOUB.RECVR_LEGAL_ENTITY_ID
AND (( ( PCOUB.PRVDR_CC_ALLOW_IU_FLAG = 'Y'
AND NVL(CO.PRVDR_ALLOW_CC_FLAG
, -99) <> 'N') OR NVL(CO.PRVDR_ALLOW_CC_FLAG
, '-') = 'Y') )) OR ((PCOUB.PRVDR_LEGAL_ENTITY_ID < > PCOUB.RECVR_LEGAL_ENTITY_ID
AND NVL(CO.PRVDR_ALLOW_CC_FLAG
, '-') = 'Y'
AND ( CO.PRVDR_PROJECT_ID IS NOT NULL
AND CO.VENDOR_SITE_ID IS NOT NULL
AND CO.CROSS_CHARGE_CODE = 'I') OR CO.CROSS_CHARGE_CODE = 'N') ))

Columns