VIEW: APPS.WSH_DSNO_ITEMS_SPECIFIC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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