Product: | RLM - Release Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RLM_HRZ_SCHEDULE_LINES_V |
SELECT HEADER_ID
, CUSTOMER_ITEM_ID
, SHIP_TO_ADDRESS_ID
, SHIP_FROM_ORG_ID
, CUST_SHIP_FROM_ORG_EXT
, CUST_SHIP_TO_EXT
, CUSTOMER_ITEM_EXT
, ITEM_DETAIL_TYPE
, ITEM_DETAIL_SUBTYPE
, TO_DATE(TO_CHAR(START_DATE_TIME
, 'DD-MON-RR')) START_DATE_TIME
, SUM(ITEM_DETAIL_QUANTITY) ITEM_DETAIL_QUANTITY
, QTY_TYPE_CODE
, UOM_CODE
, ORIGIN_TABLE
FROM RLM_SCHEDULE_INTERFACE_LINES_V
WHERE ITEM_DETAIL_TYPE IN ('0'
, '1'
, '2') GROUP BY HEADER_ID
, CUSTOMER_ITEM_ID
, SHIP_TO_ADDRESS_ID
, SHIP_FROM_ORG_ID
, CUST_SHIP_FROM_ORG_EXT
, CUST_SHIP_TO_EXT
, CUSTOMER_ITEM_EXT
, ITEM_DETAIL_TYPE
, ITEM_DETAIL_SUBTYPE
, TO_DATE(TO_CHAR(START_DATE_TIME
, 'DD-MON-RR'))
, QTY_TYPE_CODE
, UOM_CODE
, ORIGIN_TABLE ORDER BY START_DATE_TIME