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_HEADERS_V

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

View Text

SELECT DISTINCT MP.PLAN_ID HEADER_ID
, MP.COMPILE_DESIGNATOR SCHEDULE_REFERENCE_NUM
, MP.PLAN_START_DATE SCHED_HORIZON_START_DATE
, 'SCHSTART' SCHSTART_ATTVALUE
, MP.CUTOFF_DATE SCHED_HORIZON_END_DATE
, 'SCHEND' SCHEND_ATTVALUE
, 'ADD' SCHEDULE_PURPOSE
, 'Y' ACK_REQUEST
, SYSDATE SCHED_GENERATION_DATE
, 'GENERATION' DOCUMENT_ATTVALUE
, 'SOLDTO' CUST_DUMMY
, HP.PARTY_NAME CUSTOMER_NAME
, '1' INDEX1
, '0' CUSTOMER_ONETIME_FLAG
, MSD.PUBLISHER_ORG_ID CUSTOMER_SITE_ID
, 'SUPPLIER' SUPP_DUMMY
, EXD.XREF_EXT_VALUE SUPPLIER_NAME
, '2' INDEX2
, '0' SUPPLIER_ONETIME_FLAG
, MSD.SUBSCRIBER_ORG_ID SUPPLIER_SITE_ID
, 'CREATION' CREATION_ATTVALUE
FROM MSC_SUP_DEM_ENTRIES MSD
, MSC_PLANS MP
, HZ_PARTIES HP
, POM_OPERATOR_PARAMETERS POM
, ECT_XREF_DTL EXD
WHERE MP.PLAN_ID = MSD.PLAN_ID
AND MP.SR_INSTANCE_ID = MSD.SR_INSTANCE_ID
AND MP.PLAN_TYPE = 4
AND MSD.PUBLISHER_ORG_ID = HP.PARTY_ID
AND TO_CHAR(MSD.SUBSCRIBER_ORG_ID) = EXD.XREF_INT_VALUE
AND MSD.PUBLISHER_ORG_ID = EXD.PARTY_ID
AND EXD.DIRECTION = 'OUT'

Columns

Name
HEADER_ID
SCHEDULE_REFERENCE_NUM
SCHED_HORIZON_START_DATE
SCHSTART_ATTVALUE
SCHED_HORIZON_END_DATE
SCHEND_ATTVALUE
SCHEDULE_PURPOSE
ACK_REQUEST
SCHED_GENERATION_DATE
DOCUMENT_ATTVALUE
CUST_DUMMY
CUSTOMER_NAME
INDEX1
CUSTOMER_ONETIME_FLAG
CUSTOMER_SITE_ID
SUPP_DUMMY
SUPPLIER_NAME
INDEX2
SUPPLIER_ONETIME_FLAG
SUPPLIER_SITE_ID
CREATION_ATTVALUE