Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_RECVR_CC_ORG_REL_V |
SELECT E.ROWID
, E.RECVR_ORG_ID
, E.PRVDR_ORG_ID
, H.NAME RECEIVER_ORG_NAME
, H.DEFAULT_LEGAL_CONTEXT_ID RECVR_LEGAL_ENTITY_ID
, XEP.NAME RECVR_LEGAL_ENTITY_NAME
, E.PRVDR_ALLOW_CC_FLAG
, E.CROSS_CHARGE_CODE
, E.PRVDR_PROJECT_ID
, P.SEGMENT1 PROVIDER_PROJECT_NAME
, E.INVOICE_GROUPING_CODE
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.LAST_UPDATE_LOGIN
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.ATTRIBUTE11
, E.ATTRIBUTE12
, E.ATTRIBUTE13
, E.ATTRIBUTE14
, E.ATTRIBUTE15
, H.BUSINESS_GROUP_ID
, E.AP_INV_EXP_TYPE
, E.AP_INV_EXP_ORGANIZATION_ID
, E.VENDOR_SITE_ID
FROM HR_OPERATING_UNITS H
, XLE_ENTITY_PROFILES XEP
, PA_PROJECTS_ALL P
, PA_CC_ORG_RELATIONSHIPS E
WHERE E.PRVDR_PROJECT_ID = P.PROJECT_ID(+)
AND E.RECVR_ORG_ID = H.ORGANIZATION_ID AND H.DEFAULT_LEGAL_CONTEXT_ID = XEP.LEGAL_ENTITY_ID