View: WSH_OPSM_ASN_ITEMS_SPECIFIC_V

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

View Text

SELECT '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.INVOICE_TO_ORG_ID
, OEL.INVOICE_TO_CONTACT_ID
, OEL.OPTION_FLAG OPTION_FLAG
, OEL.COMPONENT_CODE COMPONENT_CODE
, RSH.SCHED_GENERATION_DATE SCHED_GENERATION_DATE
, RSH.SCHEDULE_REFERENCE_NUM SCHEDULE_REFERENCE_NUM
, RSL.CUSTOMER_ITEM_REVISION CUSTOMER_ITEM_REVISION
, RSL.LETTER_CREDIT_EXPDT_EXT LETTER_CREDIT_EXPDT_EXT
, RSL.LETTER_CREDIT_EXT LETTER_CREDIT_EXT
, 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
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 OEH.HEADER_ID = OEL.HEADER_ID+0
AND DECODE(OEL.SOURCE_DOCUMENT_TYPE_ID
, 5
, OEL.SOURCE_DOCUMENT_ID
, - 999999) = RSH.HEADER_ID (+)
AND OEL.VEH_CUS_ITEM_CUM_KEY_ID+0 = RCK.CUM_KEY_ID (+)
AND DECODE(OEL.SOURCE_DOCUMENT_TYPE_ID
, 5
, OEL.SOURCE_DOCUMENT_LINE_ID
, -99999) = RSL.LINE_ID (+)