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_TRX_SUMMARY_V

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

View Text

SELECT MCI.CUSTOMER_ITEM_NUMBER
, MCI.CUSTOMER_ITEM_DESC
, RSU.LOCATION
, MIN( RDLA.PLANNED_SHIPMENT_DATE )
, MAX( RDLA.PLANNED_SHIPMENT_DATE )
, COUNT( * )
, RDLA.CUSTOMER_ITEM_ID
, RDHA.CUSTOMER_ID
, RC.CUSTOMER_NAME
, RDLA.SHIP_TO_ADDRESS_ID
FROM RLA_DEMAND_LINES RDLA
, RLA_DEMAND_HEADERS RDHA
, MTL_CUSTOMER_ITEMS MCI
, RA_SITE_USES RSU
, RA_CUSTOMERS RC
WHERE RDLA.DEMAND_HEADER_ID = RDHA.DEMAND_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'
AND RDLA.CUSTOMER_ITEM_ID = MCI.CUSTOMER_ITEM_ID GROUP BY MCI.CUSTOMER_ITEM_NUMBER
, RSU.LOCATION
, RDLA.CUSTOMER_ITEM_ID
, RDHA.CUSTOMER_ID
, RC.CUSTOMER_NAME
, RDLA.SHIP_TO_ADDRESS_ID
, MCI.CUSTOMER_ITEM_DESC

Columns

Name
CUSTOMER_ITEM_NUMBER
CUSTOMER_ITEM_DESC
SHIP_TO_ADDRESS
DATE_FROM
DATE_TO
NUMBER_OF_TRANSMISSIONS
CUSTOMER_ITEM_ID
CUSTOMER_ID
CUSTOMER_NAME
SHIP_TO_ADDRESS_ID