VIEW: APPS.PA_CROSS_CHARGEABLE_OU_V

Source

View Text - Preformatted

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') ))

View Text - HTML Formatted

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') ))