VIEW: APPS.PA_RECVR_CC_ORG_REL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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