[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 |