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_LINES_V

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

View Text

SELECT RDLA.DEMAND_LINE_ID
, RDHA.CUSTOMER_ID
, RDLA.SHIP_TO_ADDRESS_ID
, RC.CUSTOMER_NAME
, RSU.LOCATION
, MCI.CUSTOMER_ITEM_NUMBER
, MCI.CUSTOMER_ITEM_DESC
, RDLA.CUSTOMER_JOB_NUMBER
, RDLA.PLANNED_SHIPMENT_DATE
, RDLA.QUANTITY
, MUOM.UNIT_OF_MEASURE
, RDLA.CUSTOMER_PRODUCTION_LINE
, RDLA.INDUSTRY_ATTRIBUTE2
, RDLA.LAST_UPDATE_DATE
, TO_CHAR(RDLA.LAST_UPDATE_DATE
, 'HH24:MI:SS')
, RDLA.CUSTOMER_ITEM_ID
, RDHA.ORDER_NUMBER
, RDHA.ORDER_HEADER_ID
, RDLA.FORECAST_DESIGNATOR
, RDLA.PROCESS_STATUS
, RDLA.DOCUMENT_TYPE
FROM RLA_DEMAND_LINES RDLA
, RLA_DEMAND_HEADERS RDHA
, MTL_CUSTOMER_ITEMS MCI
, MTL_UNITS_OF_MEASURE MUOM
, 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
AND RDLA.UOM_CODE = MUOM.UOM_CODE(+)

Columns

Name
DEMAND_LINE_ID
CUSTOMER_ID
SHIP_TO_ADDRESS_ID
CUSTOMER_NAME
SHIP_TO
CUSTOMER_ITEM_NUMBER
CUSTOMER_ITEM_DESC
CUSTOMER_JOB_NUMBER
SHIP_DATE
QUANTITY
UOM
CUSTOMER_PRODUCTION_LINE
CUSTOMER_PRODUCTION_SEQ_NUMBER
PROCESS_DATE
PROCESS_TIME
CUSTOMER_ITEM_ID
ORDER_NUMBER
ORDER_HEADER_ID
FORECAST_DESIGNATOR
PROCESS_STATUS
DEMAND_TYPE