Skip to content FND Design Data [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