View: PA_PRVDR_CC_ORG_REL_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PRVDR_CC_ORG_REL_V

View Text

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(+)

Columns