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_DETAILS_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
, MIN(PRODUCTION_SEQUENCE) PROD_SEQ_NUM_START
, MAX(PRODUCTION_SEQUENCE) PROD_SEQ_NUM_END
FROM MSC_SUP_DEM_ENTRIES MSD
, MSC_PLANS MP
WHERE MP.PLAN_ID = MSD.PLAN_ID
AND MP.PLAN_TYPE = 4 GROUP BY MP.PLAN_ID
, MSD.START_DATE

Columns

Name
HEADER_ID
START_DATE
STARTDATE_ATTVALUE
PROD_SEQ_NUM_START
PROD_SEQ_NUM_END