eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSH_OPSM_ASN_ITEMS_SPECIFIC_V

Source

View Text - Preformatted


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 (+)

View Text - HTML Formatted

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 (+)