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.

[Home] [Help]

View: ICX_DEMAND_ORDERS_SUM_V

Product:	ICX - Oracle iProcurement
Description:	Demand Transmissions Summary View by Order Number
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SHA.ORDER_NUMBER
, RDHA.ORDER_HEADER_ID
, RSU.LOCATION
, MIN( RDLA.PLANNED_SHIPMENT_DATE )
, MAX( RDLA.PLANNED_SHIPMENT_DATE )
, COUNT( * )
, RDHA.CUSTOMER_ID
, RC.CUSTOMER_NAME
, RDLA.SHIP_TO_ADDRESS_ID
FROM RLA_DEMAND_LINES_ALL RDLA
, RLA_DEMAND_HEADERS_ALL RDHA
, SO_HEADERS_ALL SHA
, RA_SITE_USES_ALL RSU
, RA_CUSTOMERS RC
WHERE RDLA.DEMAND_HEADER_ID = RDHA.DEMAND_HEADER_ID
AND SHA.HEADER_ID = RDHA.ORDER_HEADER_ID
AND RDHA.CUSTOMER_ID = RC.CUSTOMER_ID
AND RDLA.SHIP_TO_ADDRESS_ID = RSU.ADDRESS_ID
AND RSU.SITE_USE_CODE = 'SHIP_TO'
AND RSU.STATUS = 'A' GROUP BY RDHA.ORDER_HEADER_ID
, SHA.ORDER_NUMBER
, RSU.LOCATION
, RDHA.CUSTOMER_ID
, RC.CUSTOMER_NAME
, RDLA.SHIP_TO_ADDRESS_ID

Columns

Name
ORDER_NUMBER
ORDER_HEADER_ID
SHIP_TO_ADDRESS
DATE_FROM
DATE_TO
NUMBER_OF_TRANSMISSIONS
CUSTOMER_ID
CUSTOMER_NAME
SHIP_TO_ADDRESS_ID