VIEW: APPS.ECE_INO_HEADER_1_V

Source

View Text - Preformatted

SELECT RCTL.CUSTOMER_TRX_ID TRANSACTION_ID, MP.ORGANIZATION_CODE SHIP_FROM_CODE_INT, null EQUIPMENT_PREFIX, to_number(null) EQUIPMENT_NUMBER, null ROUTING_INSTRUCTIONS, to_number(null) PACKING_SLIP_NUMBER, RCTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, RCTL.LINE_TYPE LINE_TYPE, to_number(NULL) 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, RCTL.INTERFACE_LINE_ATTRIBUTE3 DELIVERY_ID FROM RA_CUSTOMER_TRX RCT, RA_CUSTOMER_TRX_LINES RCTL, 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_ATTRIBUTE10=to_char(HAO.ORGANIZATION_ID(+)) AND RCTL.LINE_TYPE(+) = 'LINE' AND RCT.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_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(+))

View Text - HTML Formatted

SELECT RCTL.CUSTOMER_TRX_ID TRANSACTION_ID
, MP.ORGANIZATION_CODE SHIP_FROM_CODE_INT
, NULL EQUIPMENT_PREFIX
, TO_NUMBER(NULL) EQUIPMENT_NUMBER
, NULL ROUTING_INSTRUCTIONS
, TO_NUMBER(NULL) PACKING_SLIP_NUMBER
, RCTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, RCTL.LINE_TYPE LINE_TYPE
, TO_NUMBER(NULL) 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
, RCTL.INTERFACE_LINE_ATTRIBUTE3 DELIVERY_ID
FROM RA_CUSTOMER_TRX RCT
, RA_CUSTOMER_TRX_LINES RCTL
, 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_ATTRIBUTE10=TO_CHAR(HAO.ORGANIZATION_ID(+))
AND RCTL.LINE_TYPE(+) = 'LINE'
AND RCT.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_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(+))