VIEW: APPS.RLM_HRZ_SCHEDULE_LINES_V

Source

View Text - Preformatted

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-MM-RRRR'),'DD-MM-RRRR') start_date_time, sum(item_detail_quantity) item_detail_quantity, qty_type_code, uom_code, origin_table, org_Id 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-MM-RRRR'),'DD-MM-RRRR'), qty_type_code, uom_code, origin_table, org_id order by start_date_time

View Text - HTML Formatted

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-MM-RRRR')
, 'DD-MM-RRRR') START_DATE_TIME
, SUM(ITEM_DETAIL_QUANTITY) ITEM_DETAIL_QUANTITY
, QTY_TYPE_CODE
, UOM_CODE
, ORIGIN_TABLE
, ORG_ID
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-MM-RRRR')
, 'DD-MM-RRRR')
, QTY_TYPE_CODE
, UOM_CODE
, ORIGIN_TABLE
, ORG_ID ORDER BY START_DATE_TIME