Product: | DPP - Oracle Price Protection |
---|---|
Description: | Dpp SLA Cost Update Header View |
Implementation/DBA Data: | APPS.DPP_XLA_INV_HEADERS_V |
SELECT XEG.EVENT_ID
, 'PP_COST_UPDATE' DISTRIBUTION_TYPE
, DTH.TRANSACTION_HEADER_ID
, DXH.BASE_TRANSACTION_HEADER_ID
, DTH.TRANSACTION_NUMBER
, ASP.VENDOR_NAME VENDOR_NAME
, ASS.VENDOR_SITE_CODE
, 'Y'
, DPP_XLA_EVENT_PUB.GET_PP_ACCRUAL_CCID(DTH.ORG_ID
, DTH.VENDOR_ID
, DTH.VENDOR_SITE_ID) PP_ACCRUAL_CCID
, DPP_XLA_EVENT_PUB.GET_PP_COST_ADJUSTMENT_CCID(DTH.ORG_ID
, DTH.VENDOR_ID
, DTH.VENDOR_SITE_ID ) PP_COST_ADJ_CCID
, DPP_XLA_EVENT_PUB.GET_PP_CONTRA_LIAB_CCID( DTH.ORG_ID
, DTH.VENDOR_ID
, DTH.VENDOR_SITE_ID ) PP_CONTRA_LIAB_CCID
, DTH.ATTRIBUTE_CATEGORY
, DTH.ATTRIBUTE1
, DTH.ATTRIBUTE2
, DTH.ATTRIBUTE3
, DTH.ATTRIBUTE4
, DTH.ATTRIBUTE5
, DTH.ATTRIBUTE6
, DTH.ATTRIBUTE7
, DTH.ATTRIBUTE8
, DTH.ATTRIBUTE9
, DTH.ATTRIBUTE10
, DTH.ATTRIBUTE11
, DTH.ATTRIBUTE12
, DTH.ATTRIBUTE13
, DTH.ATTRIBUTE14
, DTH.ATTRIBUTE15
, DTH.ATTRIBUTE16
, DTH.ATTRIBUTE17
, DTH.ATTRIBUTE18
, DTH.ATTRIBUTE19
, DTH.ATTRIBUTE20
, DTH.ATTRIBUTE21
, DTH.ATTRIBUTE22
, DTH.ATTRIBUTE23
, DTH.ATTRIBUTE24
, DTH.ATTRIBUTE25
, DTH.ATTRIBUTE26
, DTH.ATTRIBUTE27
, DTH.ATTRIBUTE28
, DTH.ATTRIBUTE29
, DTH.ATTRIBUTE30
, DTH.CONTACT_EMAIL_ADDRESS
, DTH.CONTACT_PHONE
, DTH.TRANSACTION_SOURCE
, DTH.EFFECTIVE_START_DATE
, DTH.DAYS_COVERED
, DTH.TRX_CURRENCY
, DTH.TRANSACTION_STATUS
, ASS.ORG_ID
FROM XLA_EVENTS_GT XEG
, DPP_XLA_HEADERS DXH
, DPP_TRANSACTION_HEADERS_ALL DTH
, AP_SUPPLIERS ASP
, AP_SUPPLIER_SITES_ALL ASS
WHERE XEG.ENTITY_CODE = 'COST_UPDATE'
AND XEG.SOURCE_ID_INT_1 = DTH.TRANSACTION_HEADER_ID
AND XEG.SOURCE_ID_INT_2 = DXH.BASE_TRANSACTION_HEADER_ID
AND DXH.TRANSACTION_HEADER_ID = DTH.TRANSACTION_HEADER_ID
AND DXH.PP_TRANSACTION_TYPE = 'COST_UPDATE'
AND DXH.PROCESSED_FLAG='P'
AND ASP.VENDOR_ID=DTH.VENDOR_ID
AND ASS.VENDOR_SITE_ID=DTH.VENDOR_SITE_ID
AND ASS.ORG_ID=DTH.ORG_ID