View: WSH_DSNO_ITEMS_SPECIFIC_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_DSNO_ITEMS_SPECIFIC_V

View Text

SELECT DISTINCT 'OE' SOURCE_CODE
, OEL.HEADER_ID ORDER_HEADER_ID
, OEL.LINE_ID ORDER_LINE_ID
, OEL.SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID
, OEL.LINK_TO_LINE_ID LINK_TO_LINE_ID
, OEL.ORIG_SYS_LINE_REF ORIGINAL_SYSTEM_LINE_REFERENCE
, TO_CHAR(OEL.LINE_NUMBER) ORDER_LINE_NUMBER
, OEH.ORDER_DATE_TYPE_CODE ORDER_DATE_TYPE_CODE
, OEL.PROMISE_DATE PROMISE_DATE
, OEL.ITEM_TYPE_CODE ITEM_TYPE_CODE_INT
, OEL.UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, OEL.OPTION_FLAG OPTION_FLAG
, OEL.COMPONENT_CODE COMPONENT_CODE
, OEL.PRICING_CONTEXT ORDER_LINE_PRICING_CONTEXT
, OEL.PRICING_ATTRIBUTE1 ORDER_LINE_PRICING_ATTRIBUTE1
, OEL.PRICING_ATTRIBUTE2 ORDER_LINE_PRICING_ATTRIBUTE2
, OEL.PRICING_ATTRIBUTE3 ORDER_LINE_PRICING_ATTRIBUTE3
, OEL.PRICING_ATTRIBUTE4 ORDER_LINE_PRICING_ATTRIBUTE4
, OEL.PRICING_ATTRIBUTE5 ORDER_LINE_PRICING_ATTRIBUTE5
, OEL.PRICING_ATTRIBUTE6 ORDER_LINE_PRICING_ATTRIBUTE6
, OEL.PRICING_ATTRIBUTE7 ORDER_LINE_PRICING_ATTRIBUTE7
, OEL.PRICING_ATTRIBUTE8 ORDER_LINE_PRICING_ATTRIBUTE8
, OEL.PRICING_ATTRIBUTE9 ORDER_LINE_PRICING_ATTRIBUTE9
, OEL.PRICING_ATTRIBUTE10 ORDER_LINE_PRICING_ATTRIBUTE10
, OEL.CONTEXT ORDER_LINE_CONTEXT
, OEL.ATTRIBUTE1 ORDER_LINE_ATTRIBUTE1
, OEL.ATTRIBUTE2 ORDER_LINE_ATTRIBUTE2
, OEL.ATTRIBUTE3 ORDER_LINE_ATTRIBUTE3
, OEL.ATTRIBUTE4 ORDER_LINE_ATTRIBUTE4
, OEL.ATTRIBUTE5 ORDER_LINE_ATTRIBUTE5
, OEL.ATTRIBUTE6 ORDER_LINE_ATTRIBUTE6
, OEL.ATTRIBUTE7 ORDER_LINE_ATTRIBUTE7
, OEL.ATTRIBUTE8 ORDER_LINE_ATTRIBUTE8
, OEL.ATTRIBUTE9 ORDER_LINE_ATTRIBUTE9
, OEL.ATTRIBUTE10 ORDER_LINE_ATTRIBUTE10
, OEL.ATTRIBUTE11 ORDER_LINE_ATTRIBUTE11
, OEL.ATTRIBUTE12 ORDER_LINE_ATTRIBUTE12
, OEL.ATTRIBUTE13 ORDER_LINE_ATTRIBUTE13
, OEL.ATTRIBUTE14 ORDER_LINE_ATTRIBUTE14
, OEL.ATTRIBUTE15 ORDER_LINE_ATTRIBUTE15
, OEL.GLOBAL_ATTRIBUTE_CATEGORY OELINE_GLOBAL_ATTRIB_CATEGORY
, OEL.GLOBAL_ATTRIBUTE1 OELINE_GLOBAL_ATTRIBUTE1
, OEL.GLOBAL_ATTRIBUTE2 OELINE_GLOBAL_ATTRIBUTE2
, OEL.GLOBAL_ATTRIBUTE3 OELINE_GLOBAL_ATTRIBUTE3
, OEL.GLOBAL_ATTRIBUTE4 OELINE_GLOBAL_ATTRIBUTE4
, OEL.GLOBAL_ATTRIBUTE5 OELINE_GLOBAL_ATTRIBUTE5
, OEL.GLOBAL_ATTRIBUTE6 OELINE_GLOBAL_ATTRIBUTE6
, OEL.GLOBAL_ATTRIBUTE7 OELINE_GLOBAL_ATTRIBUTE7
, OEL.GLOBAL_ATTRIBUTE8 OELINE_GLOBAL_ATTRIBUTE8
, OEL.GLOBAL_ATTRIBUTE9 OELINE_GLOBAL_ATTRIBUTE9
, OEL.GLOBAL_ATTRIBUTE10 OELINE_GLOBAL_ATTRIBUTE10
, OEL.GLOBAL_ATTRIBUTE11 OELINE_GLOBAL_ATTRIBUTE11
, OEL.GLOBAL_ATTRIBUTE12 OELINE_GLOBAL_ATTRIBUTE12
, OEL.GLOBAL_ATTRIBUTE13 OELINE_GLOBAL_ATTRIBUTE13
, OEL.GLOBAL_ATTRIBUTE14 OELINE_GLOBAL_ATTRIBUTE14
, OEL.GLOBAL_ATTRIBUTE15 OELINE_GLOBAL_ATTRIBUTE15
, OEL.GLOBAL_ATTRIBUTE16 OELINE_GLOBAL_ATTRIBUTE16
, OEL.GLOBAL_ATTRIBUTE17 OELINE_GLOBAL_ATTRIBUTE17
, OEL.GLOBAL_ATTRIBUTE18 OELINE_GLOBAL_ATTRIBUTE18
, OEL.GLOBAL_ATTRIBUTE19 OELINE_GLOBAL_ATTRIBUTE19
, OEL.GLOBAL_ATTRIBUTE20 OELINE_GLOBAL_ATTRIBUTE20
, OEL.INDUSTRY_CONTEXT OELINE_INDUSTRY_CONTEXT
, OEL.INDUSTRY_ATTRIBUTE1 OELINE_INDUSTRY_ATTRIBUTE1
, OEL.INDUSTRY_ATTRIBUTE2 OELINE_INDUSTRY_ATTRIBUTE2
, OEL.INDUSTRY_ATTRIBUTE3 OELINE_INDUSTRY_ATTRIBUTE3
, OEL.INDUSTRY_ATTRIBUTE4 OELINE_INDUSTRY_ATTRIBUTE4
, OEL.INDUSTRY_ATTRIBUTE5 OELINE_INDUSTRY_ATTRIBUTE5
, OEL.INDUSTRY_ATTRIBUTE6 OELINE_INDUSTRY_ATTRIBUTE6
, OEL.INDUSTRY_ATTRIBUTE7 OELINE_INDUSTRY_ATTRIBUTE7
, OEL.INDUSTRY_ATTRIBUTE8 OELINE_INDUSTRY_ATTRIBUTE8
, OEL.INDUSTRY_ATTRIBUTE9 OELINE_INDUSTRY_ATTRIBUTE9
, OEL.INDUSTRY_ATTRIBUTE10 OELINE_INDUSTRY_ATTRIBUTE10
, OEL.INDUSTRY_ATTRIBUTE11 OELINE_INDUSTRY_ATTRIBUTE11
, OEL.INDUSTRY_ATTRIBUTE12 OELINE_INDUSTRY_ATTRIBUTE12
, OEL.INDUSTRY_ATTRIBUTE13 OELINE_INDUSTRY_ATTRIBUTE13
, OEL.INDUSTRY_ATTRIBUTE14 OELINE_INDUSTRY_ATTRIBUTE14
, OEL.INDUSTRY_ATTRIBUTE15 OELINE_INDUSTRY_ATTRIBUTE15
, OEL.TP_CONTEXT ORDER_LINE_TP_CONTEXT
, OEL.TP_ATTRIBUTE1 ORDER_LINE_TP_ATTRIBUTE1
, OEL.TP_ATTRIBUTE2 ORDER_LINE_TP_ATTRIBUTE2
, OEL.TP_ATTRIBUTE3 ORDER_LINE_TP_ATTRIBUTE3
, OEL.TP_ATTRIBUTE4 ORDER_LINE_TP_ATTRIBUTE4
, OEL.TP_ATTRIBUTE5 ORDER_LINE_TP_ATTRIBUTE5
, OEL.TP_ATTRIBUTE6 ORDER_LINE_TP_ATTRIBUTE6
, OEL.TP_ATTRIBUTE7 ORDER_LINE_TP_ATTRIBUTE7
, OEL.TP_ATTRIBUTE8 ORDER_LINE_TP_ATTRIBUTE8
, OEL.TP_ATTRIBUTE9 ORDER_LINE_TP_ATTRIBUTE9
, OEL.TP_ATTRIBUTE10 ORDER_LINE_TP_ATTRIBUTE10
, OEL.TP_ATTRIBUTE11 ORDER_LINE_TP_ATTRIBUTE11
, OEL.TP_ATTRIBUTE12 ORDER_LINE_TP_ATTRIBUTE12
, OEL.TP_ATTRIBUTE13 ORDER_LINE_TP_ATTRIBUTE13
, OEL.TP_ATTRIBUTE14 ORDER_LINE_TP_ATTRIBUTE14
, OEL.TP_ATTRIBUTE15 ORDER_LINE_TP_ATTRIBUTE15
, RSH.HEADER_REF_CODE_1 HEADER_REF_CODE_1
, RSH.HEADER_REF_CODE_2 HEADER_REF_CODE_2
, RSH.HEADER_REF_CODE_3 HEADER_REF_CODE_3
, RSH.HEADER_REF_VALUE_1 HEADER_REF_VALUE_1
, RSH.HEADER_REF_VALUE_2 HEADER_REF_VALUE_2
, RSH.HEADER_REF_VALUE_3 HEADER_REF_VALUE_3
, RSH.SCHED_GENERATION_DATE SCHED_GENERATION_DATE
, RSH.SCHEDULE_REFERENCE_NUM SCHEDULE_REFERENCE_NUM
, RSL.COMMODITY_EXT COMMODITY_EXT
, RSL.COUNTRY_OF_ORIGIN_EXT COUNTRY_OF_ORIGIN_EXT
, RSL.CUST_ASSIGNED_ID_EXT CUST_ASSIGNED_ID_EXT
, RSL.CUST_CONTRACT_NUM_EXT CUST_CONTRACT_NUM_EXT
, RSL.CUST_MANUFACTURER_EXT CUST_MANUFACTURER_EXT
, RSL.CUST_MODEL_NUMBER_EXT CUST_MODEL_NUMBER_EXT
, RSL.INDUSTRY_ATTRIBUTE1 RLM_INDUSTRY_ATTRIBUTE1
, RSL.CUST_ORDER_NUM_EXT CUST_ORDER_NUM_EXT
, RSL.CUST_PROCESS_NUM_EXT CUST_PROCESS_NUM_EXT
, RSL.CUST_SET_NUM_EXT CUST_SET_NUM_EXT
, RSL.EQUIPMENT_CODE_EXT EQUIPMENT_CODE_EXT
, RSL.EQUIPMENT_NUMBER_EXT EQUIPMENT_NUMBER_EXT
, RSL.HANDLING_CODE_EXT HANDLING_CODE_EXT
, RSL.HAZARD_CODE_QUAL_EXT HAZARD_CODE_QUAL_EXT
, RSL.HAZARD_CODE_EXT HAZARD_CODE_EXT
, RSL.HAZARD_DESCRIPTION_EXT HAZARD_DESCRIPTION_EXT
, RSL.IMPORT_LICENSE_DATE_EXT IMPORT_LICENSE_DATE_EXT
, RSL.IMPORT_LICENSE_EXT IMPORT_LICENSE_EXT
, RSL.ITEM_DETAIL_REF_CODE_1 ITEM_DETAIL_REF_CODE_1
, RSL.ITEM_DETAIL_REF_CODE_2 ITEM_DETAIL_REF_CODE_2
, RSL.ITEM_DETAIL_REF_CODE_3 ITEM_DETAIL_REF_CODE_3
, RSL.ITEM_DETAIL_REF_VALUE_1 ITEM_DETAIL_REF_VALUE_1
, RSL.ITEM_DETAIL_REF_VALUE_2 ITEM_DETAIL_REF_VALUE_2
, RSL.ITEM_DETAIL_REF_VALUE_3 ITEM_DETAIL_REF_VALUE_3
, RSL.ITEM_ENG_CNG_LVL_EXT ITEM_ENG_CNG_LVL_EXT
, RSL.TRANSPORT_METHOD_EXT TRANSPORT_METHOD_EXT
, RSL.ITEM_REF_CODE_1 ITEM_REF_CODE_1
, RSL.ITEM_REF_CODE_2 ITEM_REF_CODE_2
, RSL.ITEM_REF_CODE_3 ITEM_REF_CODE_3
, RSL.ITEM_REF_VALUE_1 ITEM_REF_VALUE_1
, RSL.ITEM_REF_VALUE_2 ITEM_REF_VALUE_2
, RSL.ITEM_REF_VALUE_3 ITEM_REF_VALUE_3
, RSL.CUSTOMER_ITEM_REVISION CUSTOMER_ITEM_REVISION
, RSL.LETTER_CREDIT_EXPDT_EXT LETTER_CREDIT_EXPDT_EXT
, RSL.LETTER_CREDIT_EXT LETTER_CREDIT_EXT
, RSL.ATTRIBUTE_CATEGORY RLM_ATTRIBUTE_CATEGORY
, RSL.ATTRIBUTE1 RLM_ATTRIBUTE1
, RSL.ATTRIBUTE2 RLM_ATTRIBUTE2
, RSL.ATTRIBUTE3 RLM_ATTRIBUTE3
, RSL.ATTRIBUTE4 RLM_ATTRIBUTE4
, RSL.ATTRIBUTE5 RLM_ATTRIBUTE5
, RSL.ATTRIBUTE6 RLM_ATTRIBUTE6
, RSL.ATTRIBUTE7 RLM_ATTRIBUTE7
, RSL.ATTRIBUTE8 RLM_ATTRIBUTE8
, RSL.ATTRIBUTE9 RLM_ATTRIBUTE9
, RSL.ATTRIBUTE10 RLM_ATTRIBUTE10
, RSL.ATTRIBUTE11 RLM_ATTRIBUTE11
, RSL.ATTRIBUTE12 RLM_ATTRIBUTE12
, RSL.ATTRIBUTE13 RLM_ATTRIBUTE13
, RSL.ATTRIBUTE14 RLM_ATTRIBUTE14
, RSL.ATTRIBUTE15 RLM_ATTRIBUTE15
, RSL.PACKAGING_CODE_EXT PACKAGING_CODE_EXT
, RSL.PRIME_CONTRCTR_PART_EXT PRIME_CONTRCTR_PART_EXT
, RSL.INDUSTRY_ATTRIBUTE4 PULLSIGNAL_REF_NUM
, RSL.INDUSTRY_ATTRIBUTE5 PULLSIGNAL_START_SERIAL
, RSL.INDUSTRY_ATTRIBUTE6 PULLSIGNAL_END_SERIAL
, RSL.CUST_PO_RELEASE_NUM CUST_PO_RELEASE_NUM
, RSL.CUST_PO_DATE CUST_PO_DATE
, NVL(OEL.CUSTOMER_LINE_NUMBER
, RSL.CUST_PO_LINE_NUM) CUST_PO_LINE_NUM
, RSL.SUPPLIER_ITEM_EXT SUPPLIER_ITEM_EXT
, RCK.CUM_START_DATE CUM_START_DATE
, WSH_ECE_VIEWS_DEF.GET_CUST_PAYMENT_TERM(NVL(OEL.CUSTOMER_PAYMENT_TERM_ID
, OEH.PAYMENT_TERM_ID)) CUST_PAYMENT_TERMS_INT
FROM RLM_SCHEDULE_HEADERS_ALL RSH
, RLM_CUST_ITEM_CUM_KEYS_ALL RCK
, RLM_SCHEDULE_LINES_ALL RSL
, OE_ORDER_HEADERS_ALL OEH
, OE_ORDER_LINES_ALL OEL
WHERE DECODE(OEL.SOURCE_DOCUMENT_TYPE_ID
, 5
, OEL.SOURCE_DOCUMENT_ID
, - 999999) = RSH.HEADER_ID (+)
AND OEL.VEH_CUS_ITEM_CUM_KEY_ID = RCK.CUM_KEY_ID (+)
AND DECODE(OEL. SOURCE_DOCUMENT_TYPE_ID
, 5
, OEL.SOURCE_DOCUMENT_LINE_ID
, -99999) = RSL.LINE_ID (+)
AND OEH.HEADER_ID = OEL.HEADER_ID UNION ALL SELECT DISTINCT 'OKE' SOURCE_CODE
, OKH.K_HEADER_ID ORDER_HEADER_ID
, OKD.DELIVERABLE_ID ORDER_LINE_ID
, 0 SPLIT_FROM_LINE_ID
, OKL.CLE_ID LINK_TO_LINE_ID
, NULL ORIGINAL_SYSTEM_LINE_REFERENCE
, OKL.LINE_NUMBER ORDER_LINE_NUMBER
, NULL ORDER_DATE_TYPE_CODE
, OKD.EXPECTED_SHIPMENT_DATE PROMISE_DATE
, NULL ITEM_TYPE_CODE_INT
, 0 UNIT_SELLING_PRICE
, NULL OPTION_FLAG
, NULL COMPONENT_CODE
, NULL ORDER_LINE_PRICING_CONTEXT
, NULL ORDER_LINE_PRICING_ATTRIBUTE1
, NULL ORDER_LINE_PRICING_ATTRIBUTE2
, NULL ORDER_LINE_PRICING_ATTRIBUTE3
, NULL ORDER_LINE_PRICING_ATTRIBUTE4
, NULL ORDER_LINE_PRICING_ATTRIBUTE5
, NULL ORDER_LINE_PRICING_ATTRIBUTE6
, NULL ORDER_LINE_PRICING_ATTRIBUTE7
, NULL ORDER_LINE_PRICING_ATTRIBUTE8
, NULL ORDER_LINE_PRICING_ATTRIBUTE9
, NULL ORDER_LINE_PRICING_ATTRIBUTE10
, OKL.ATTRIBUTE_CATEGORY ORDER_LINE_CONTEXT
, OKL.ATTRIBUTE1 ORDER_LINE_ATTRIBUTE1
, OKL.ATTRIBUTE2 ORDER_LINE_ATTRIBUTE2
, OKL.ATTRIBUTE3 ORDER_LINE_ATTRIBUTE3
, OKL.ATTRIBUTE4 ORDER_LINE_ATTRIBUTE4
, OKL.ATTRIBUTE5 ORDER_LINE_ATTRIBUTE5
, OKL.ATTRIBUTE6 ORDER_LINE_ATTRIBUTE6
, OKL.ATTRIBUTE7 ORDER_LINE_ATTRIBUTE7
, OKL.ATTRIBUTE8 ORDER_LINE_ATTRIBUTE8
, OKL.ATTRIBUTE9 ORDER_LINE_ATTRIBUTE9
, OKL.ATTRIBUTE10 ORDER_LINE_ATTRIBUTE10
, OKL.ATTRIBUTE11 ORDER_LINE_ATTRIBUTE11
, OKL.ATTRIBUTE12 ORDER_LINE_ATTRIBUTE12
, OKL.ATTRIBUTE13 ORDER_LINE_ATTRIBUTE13
, OKL.ATTRIBUTE14 ORDER_LINE_ATTRIBUTE14
, OKL.ATTRIBUTE15 ORDER_LINE_ATTRIBUTE15
, NULL OELINE_GLOBAL_ATTRIB_CATEGORY
, NULL OELINE_GLOBAL_ATTRIBUTE1
, NULL OELINE_GLOBAL_ATTRIBUTE2
, NULL OELINE_GLOBAL_ATTRIBUTE3
, NULL OELINE_GLOBAL_ATTRIBUTE4
, NULL OELINE_GLOBAL_ATTRIBUTE5
, NULL OELINE_GLOBAL_ATTRIBUTE6
, NULL OELINE_GLOBAL_ATTRIBUTE7
, NULL OELINE_GLOBAL_ATTRIBUTE8
, NULL OELINE_GLOBAL_ATTRIBUTE9
, NULL OELINE_GLOBAL_ATTRIBUTE10
, NULL OELINE_GLOBAL_ATTRIBUTE11
, NULL OELINE_GLOBAL_ATTRIBUTE12
, NULL OELINE_GLOBAL_ATTRIBUTE13
, NULL OELINE_GLOBAL_ATTRIBUTE14
, NULL OELINE_GLOBAL_ATTRIBUTE15
, NULL OELINE_GLOBAL_ATTRIBUTE16
, NULL OELINE_GLOBAL_ATTRIBUTE17
, NULL OELINE_GLOBAL_ATTRIBUTE18
, NULL OELINE_GLOBAL_ATTRIBUTE19
, NULL OELINE_GLOBAL_ATTRIBUTE20
, NULL OELINE_INDUSTRY_CONTEXT
, NULL OELINE_INDUSTRY_ATTRIBUTE1
, NULL OELINE_INDUSTRY_ATTRIBUTE2
, NULL OELINE_INDUSTRY_ATTRIBUTE3
, NULL OELINE_INDUSTRY_ATTRIBUTE4
, NULL OELINE_INDUSTRY_ATTRIBUTE5
, NULL OELINE_INDUSTRY_ATTRIBUTE6
, NULL OELINE_INDUSTRY_ATTRIBUTE7
, NULL OELINE_INDUSTRY_ATTRIBUTE8
, NULL OELINE_INDUSTRY_ATTRIBUTE9
, NULL OELINE_INDUSTRY_ATTRIBUTE10
, NULL OELINE_INDUSTRY_ATTRIBUTE11
, NULL OELINE_INDUSTRY_ATTRIBUTE12
, NULL OELINE_INDUSTRY_ATTRIBUTE13
, NULL OELINE_INDUSTRY_ATTRIBUTE14
, NULL OELINE_INDUSTRY_ATTRIBUTE15
, NULL ORDER_LINE_TP_CONTEXT
, NULL ORDER_LINE_TP_ATTRIBUTE1
, NULL ORDER_LINE_TP_ATTRIBUTE2
, NULL ORDER_LINE_TP_ATTRIBUTE3
, NULL ORDER_LINE_TP_ATTRIBUTE4
, NULL ORDER_LINE_TP_ATTRIBUTE5
, NULL ORDER_LINE_TP_ATTRIBUTE6
, NULL ORDER_LINE_TP_ATTRIBUTE7
, NULL ORDER_LINE_TP_ATTRIBUTE8
, NULL ORDER_LINE_TP_ATTRIBUTE9
, NULL ORDER_LINE_TP_ATTRIBUTE10
, NULL ORDER_LINE_TP_ATTRIBUTE11
, NULL ORDER_LINE_TP_ATTRIBUTE12
, NULL ORDER_LINE_TP_ATTRIBUTE13
, NULL ORDER_LINE_TP_ATTRIBUTE14
, NULL ORDER_LINE_TP_ATTRIBUTE15
, NULL HEADER_REF_CODE_1
, NULL HEADER_REF_CODE_2
, NULL HEADER_REF_CODE_3
, NULL HEADER_REF_VALUE_1
, NULL HEADER_REF_VALUE_2
, NULL HEADER_REF_VALUE_3
, TO_DATE( NULL
, 'DDMMYYYY') SCHED_GENERATION_DATE
, NULL SCHEDULE_REFERENCE_NUM
, NULL COMMODITY_EXT
, NULL COUNTRY_OF_ORIGIN_EXT
, NULL CUST_ASSIGNED_ID_EXT
, NULL CUST_CONTRACT_NUM_EXT
, NULL CUST_MANUFACTURER_EXT
, NULL CUST_MODEL_NUMBER_EXT
, NULL RLM_INDUSTRY_ATTRIBUTE1
, NULL CUST_ORDER_NUM_EXT
, NULL CUST_PROCESS_NUM_EXT
, NULL CUST_SET_NUM_EXT
, NULL EQUIPMENT_CODE_EXT
, NULL EQUIPMENT_NUMBER_EXT
, NULL HANDLING_CODE_EXT
, NULL HAZARD_CODE_QUAL_EXT
, NULL HAZARD_CODE_EXT
, NULL HAZARD_DESCRIPTION_EXT
, TO_DATE( NULL
, 'DDMMYYYY') IMPORT_LICENSE_DATE_EXT
, NULL IMPORT_LICENSE_EXT
, NULL ITEM_DETAIL_REF_CODE_1
, NULL ITEM_DETAIL_REF_CODE_2
, NULL ITEM_DETAIL_REF_CODE_3
, NULL ITEM_DETAIL_REF_VALUE_1
, NULL ITEM_DETAIL_REF_VALUE_2
, NULL ITEM_DETAIL_REF_VALUE_3
, NULL ITEM_ENG_CNG_LVL_EXT
, NULL TRANSPORT_METHOD_EXT
, NULL ITEM_REF_CODE_1
, NULL ITEM_REF_CODE_2
, NULL ITEM_REF_CODE_3
, NULL ITEM_REF_VALUE_1
, NULL ITEM_REF_VALUE_2
, NULL ITEM_REF_VALUE_3
, NULL CUSTOMER_ITEM_REVISION
, TO_DATE( NULL
, 'DDMMYYYY') LETTER_CREDIT_EXPDT_EXT
, NULL LETTER_CREDIT_EXT
, NULL RLM_ATTRIBUTE_CATEGORY
, NULL RLM_ATTRIBUTE1
, NULL RLM_ATTRIBUTE2
, NULL RLM_ATTRIBUTE3
, NULL RLM_ATTRIBUTE4
, NULL RLM_ATTRIBUTE5
, NULL RLM_ATTRIBUTE6
, NULL RLM_ATTRIBUTE7
, NULL RLM_ATTRIBUTE8
, NULL RLM_ATTRIBUTE9
, NULL RLM_ATTRIBUTE10
, NULL RLM_ATTRIBUTE11
, NULL RLM_ATTRIBUTE12
, NULL RLM_ATTRIBUTE13
, NULL RLM_ATTRIBUTE14
, NULL RLM_ATTRIBUTE15
, NULL PACKAGING_CODE_EXT
, NULL PRIME_CONTRCTR_PART_EXT
, NULL PULLSIGNAL_REF_NUM
, NULL PULLSIGNAL_START_SERIAL
, NULL PULLSIGNAL_END_SERIAL
, NULL CUST_PO_RELEASE_NUM
, TO_DATE( NULL
, 'DDMMYYYY') CUST_PO_DATE
, NULL CUST_PO_LINE_NUM
, NULL SUPPLIER_ITEM_EXT
, TO_DATE( NULL
, 'DDMMYYYY') CUM_START_DATE
, NULL CUST_PAYMENT_TERMS_INT
FROM OKE_K_HEADERS OKH
, OKC_K_LINES_B OKL
, OKE_K_DELIVERABLES_B OKD
WHERE OKH.K_HEADER_ID = OKL.DNZ_CHR_ID
AND OKH.K_HEADER_ID = OKD.K_HEADER_ID
AND OKL.ID = OKD.K_LINE_ID

Columns