View: ECE_CDMO_HEADER_1_V

Product:	EC - e-Commerce Gateway
Description:	This view extracts additional header informationfor the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.@rep:scope private@rep:product AR@rep:lifecycle active@rep:displayname Credit/Debit Memo Header Attributes View@rep:category
Implementation/DBA Data:	APPS.ECE_CDMO_HEADER_1_V

View Text

SELECT RCTL.CUSTOMER_TRX_ID TRANSACTION_ID
, MP.ORGANIZATION_CODE SHIP_FROM_CODE_INT
, RTRIM(WTP.VEHICLE_NUMBER
, '0123456789') EQUIPMENT_PREFIX
, SUBSTR(WTP.VEHICLE_NUMBER
, NVL(LENGTH(RTRIM(WTP.VEHICLE_NUMBER
, '0123456789'))
, 0) +1) EQUIPMENT_NUMBER
, SUBSTR(WTP.ROUTING_INSTRUCTIONS
, 1
, 150) ROUTING_INSTRUCTIONS
, WDI.SEQUENCE_NUMBER PACKING_SLIP_NUMBER
, RCTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, RCTL.LINE_TYPE LINE_TYPE
, WDD.DELIVERY_DETAIL_ID PICKING_LINE_ID
, RCT.INTERFACE_HEADER_CONTEXT INTERFACE_ATTRIBUTE_CATEGORY
, RCT.INTERFACE_HEADER_ATTRIBUTE1 INTERFACE_ATTRIBUTE1
, RCT.INTERFACE_HEADER_ATTRIBUTE2 INTERFACE_ATTRIBUTE2
, RCT.INTERFACE_HEADER_ATTRIBUTE3 INTERFACE_ATTRIBUTE3
, RCT.INTERFACE_HEADER_ATTRIBUTE4 INTERFACE_ATTRIBUTE4
, RCT.INTERFACE_HEADER_ATTRIBUTE5 INTERFACE_ATTRIBUTE5
, RCT.INTERFACE_HEADER_ATTRIBUTE6 INTERFACE_ATTRIBUTE6
, RCT.INTERFACE_HEADER_ATTRIBUTE7 INTERFACE_ATTRIBUTE7
, RCT.INTERFACE_HEADER_ATTRIBUTE8 INTERFACE_ATTRIBUTE8
, RCT.INTERFACE_HEADER_ATTRIBUTE9 INTERFACE_ATTRIBUTE9
, RCT.INTERFACE_HEADER_ATTRIBUTE10 INTERFACE_ATTRIBUTE10
, RCT.INTERFACE_HEADER_ATTRIBUTE11 INTERFACE_ATTRIBUTE11
, RCT.INTERFACE_HEADER_ATTRIBUTE12 INTERFACE_ATTRIBUTE12
, RCT.INTERFACE_HEADER_ATTRIBUTE13 INTERFACE_ATTRIBUTE13
, RCT.INTERFACE_HEADER_ATTRIBUTE14 INTERFACE_ATTRIBUTE14
, RCT.INTERFACE_HEADER_ATTRIBUTE15 INTERFACE_ATTRIBUTE15
, RCT.ATTRIBUTE_CATEGORY TRANSACTION_ATTRIBUTE_CATEGORY
, RCT.ATTRIBUTE1 TRANSACTION_ATTRIBUTE1
, RCT.ATTRIBUTE2 TRANSACTION_ATTRIBUTE2
, RCT.ATTRIBUTE3 TRANSACTION_ATTRIBUTE3
, RCT.ATTRIBUTE4 TRANSACTION_ATTRIBUTE4
, RCT.ATTRIBUTE5 TRANSACTION_ATTRIBUTE5
, RCT.ATTRIBUTE6 TRANSACTION_ATTRIBUTE6
, RCT.ATTRIBUTE7 TRANSACTION_ATTRIBUTE7
, RCT.ATTRIBUTE8 TRANSACTION_ATTRIBUTE8
, RCT.ATTRIBUTE9 TRANSACTION_ATTRIBUTE9
, RCT.ATTRIBUTE10 TRANSACTION_ATTRIBUTE10
, RCT.ATTRIBUTE11 TRANSACTION_ATTRIBUTE11
, RCT.ATTRIBUTE12 TRANSACTION_ATTRIBUTE12
, RCT.ATTRIBUTE13 TRANSACTION_ATTRIBUTE13
, RCT.ATTRIBUTE14 TRANSACTION_ATTRIBUTE14
, RCT.ATTRIBUTE15 TRANSACTION_ATTRIBUTE15
, TO_NUMBER(NVL(RCTL.INTERFACE_LINE_ATTRIBUTE3
, 0)) DELIVERY_ID
FROM RA_CUSTOMER_TRX_LINES RCTL
, RA_CUSTOMER_TRX RCT
, WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_LEGS WDL
, WSH_TRIP_STOPS WTS
, WSH_TRIPS WTP
, WSH_DOCUMENT_INSTANCES WDI
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HAO
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, GL_SETS_OF_BOOKS GSOB
, HR_ALL_ORGANIZATION_UNITS_TL HAOTL
WHERE RCTL.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR( WDD.SOURCE_LINE_ID(+))
AND RCTL.INTERFACE_LINE_ATTRIBUTE3 = TO_CHAR( WDL.DELIVERY_ID (+) )
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID (+)
AND WTS.TRIP_ID = WTP.TRIP_ID (+)
AND RCTL.INTERFACE_LINE_ATTRIBUTE10=TO_CHAR(HAO.ORGANIZATION_ID(+))
AND NVL(RCTL.INTERFACE_LINE_ATTRIBUTE3
, 0) = TO_CHAR( WDI.ENTITY_ID (+))
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HAO.ORGANIZATION_ID(+)))='TRUE'
AND HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID(+)
AND HAOTL.LANGUAGE (+)= USERENV('LANG')
AND MP.ORGANIZATION_ID(+) =HAO.ORGANIZATION_ID
AND HOI1.ORGANIZATION_ID = HOI2.ORGANIZATION_ID(+)
AND HAO.ORGANIZATION_ID = HOI1.ORGANIZATION_ID(+)
AND HOI1.ORG_INFORMATION_CONTEXT(+)='CLASS'
AND HOI1.ORG_INFORMATION1(+) = 'INV'
AND HOI2.ORG_INFORMATION_CONTEXT(+)='ACCOUNTING INFORMATION'
AND HOI2.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID(+))
AND RCTL.LINE_TYPE(+) = 'LINE'
AND RCT.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_ID

Columns