VIEW: APPS.PA_PRVDR_CC_ORG_REL_V

Source

View Text - Preformatted

SELECT /*+ no_merge (h) */ e.rowid, e.prvdr_org_id, e.recvr_org_id, h.name prvdr_org_name, h.default_legal_context_id prvdr_legal_entity_id, xep.name prvdr_legal_entity_name, v.vendor_name supplier_name, imp.vendor_id supplier_id, vs.vendor_site_code supplier_site_name, e.vendor_site_id supplier_site_id, e.ap_inv_exp_type, e.ap_inv_exp_organization_id, orgtl.name ap_inv_exp_organization_name, 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, e.prvdr_allow_cc_flag, e.cross_charge_code, e.prvdr_project_id, e.invoice_grouping_code FROM hr_operating_units h, xle_entity_profiles xep, hr_all_organization_units_tl orgtl, hr_org_units_no_join org, po_vendors v, po_vendor_sites_all vs, pa_implementations_all imp, pa_cc_org_relationships e WHERE h.default_legal_context_id = xep.legal_entity_id AND e.prvdr_org_id = h.organization_id AND e.prvdr_org_id = imp.org_id AND e.ap_inv_exp_organization_id = org.organization_id(+) AND org.organization_id = orgtl.organization_id(+) AND decode(orgtl.organization_id,NULL,'1',orgtl.language) = decode(orgtl.organization_id,NULL,'1',userenv('LANG')) AND imp.vendor_id = v.vendor_id(+) AND e.vendor_site_id = vs.vendor_site_id(+) AND e.recvr_org_id = vs.org_id(+)

View Text - HTML Formatted

SELECT /*+ NO_MERGE (H) */ E.ROWID
, E.PRVDR_ORG_ID
, E.RECVR_ORG_ID
, H.NAME PRVDR_ORG_NAME
, H.DEFAULT_LEGAL_CONTEXT_ID PRVDR_LEGAL_ENTITY_ID
, XEP.NAME PRVDR_LEGAL_ENTITY_NAME
, V.VENDOR_NAME SUPPLIER_NAME
, IMP.VENDOR_ID SUPPLIER_ID
, VS.VENDOR_SITE_CODE SUPPLIER_SITE_NAME
, E.VENDOR_SITE_ID SUPPLIER_SITE_ID
, E.AP_INV_EXP_TYPE
, E.AP_INV_EXP_ORGANIZATION_ID
, ORGTL.NAME AP_INV_EXP_ORGANIZATION_NAME
, 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
, E.PRVDR_ALLOW_CC_FLAG
, E.CROSS_CHARGE_CODE
, E.PRVDR_PROJECT_ID
, E.INVOICE_GROUPING_CODE
FROM HR_OPERATING_UNITS H
, XLE_ENTITY_PROFILES XEP
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, HR_ORG_UNITS_NO_JOIN ORG
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, PA_IMPLEMENTATIONS_ALL IMP
, PA_CC_ORG_RELATIONSHIPS E
WHERE H.DEFAULT_LEGAL_CONTEXT_ID = XEP.LEGAL_ENTITY_ID
AND E.PRVDR_ORG_ID = H.ORGANIZATION_ID
AND E.PRVDR_ORG_ID = IMP.ORG_ID
AND E.AP_INV_EXP_ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID(+)
AND DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, ORGTL.LANGUAGE) = DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND IMP.VENDOR_ID = V.VENDOR_ID(+)
AND E.VENDOR_SITE_ID = VS.VENDOR_SITE_ID(+)
AND E.RECVR_ORG_ID = VS.ORG_ID(+)