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: RLX_INTERFACE_LINES_V

Product:	RLM - Release Management
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MP.PLAN_ID HEADER_ID
, MSD.START_DATE START_DATE
, 'REQUIRED' STARTDATE_ATTVALUE
, IIV.PARTY_ITEM_NUMBER ITEM_NAME
, 'EACH' UOM_CODE
, MSD.QUANTITY PRIMARY_QUANTITY
, 'ITEM' QUANTITY_ATTVALUE
, MSD.PRODUCTION_SEQUENCE PROD_SEQ_NUMBER
, MSD.END_ASSEMBLY_ITEM_NAME MODEL_SERIAL_NUMBER
, MSD.LINE_CODE LINE_FEED
, 'DELIVACT' DELIVACT_ATTVALUE
, 'PO' PO_ATTVALUE
, 'RECEIVED' RECEIVED_ATTVALUE
, 'SHIP' SHIP_ATTVALUE
, 'DELIVERED' DELIVERED_ATTVALUE
, 'RECEIVED' RECEIVEDQTY_ATTVALUE
, 'SHIPPED' SHIPPED_ATTVALUE
FROM MSC_SUP_DEM_ENTRIES MSD
, IPD_ITEMS_V IIV
, MSC_PLANS MP
WHERE MSD.INVENTORY_ITEM_ID = IIV.ITEM_ID
AND MSD.PUBLISHER_ORG_ID = IIV.PARTY_ID
AND MP.PLAN_ID = MSD.PLAN_ID
AND MP.PLAN_TYPE = 4

Columns

Name
HEADER_ID
START_DATE
STARTDATE_ATTVALUE
ITEM_NAME
UOM_CODE
PRIMARY_QUANTITY
QUANTITY_ATTVALUE
PROD_SEQ_NUMBER
MODEL_SERIAL_NUMBER
LINE_FEED
DELIVACT_ATTVALUE
PO_ATTVALUE
RECEIVED_ATTVALUE
SHIP_ATTVALUE
DELIVERED_ATTVALUE
RECEIVEDQTY_ATTVALUE
SHIPPED_ATTVALUE