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.

APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ST_DESIGNATORS

Line 1077: from MSC_ST_DESIGNATORS MSD

1073: SELECT
1074: MSD.DESIGNATOR,
1075: MSD.ORGANIZATION_ID,
1076: MSD.SR_INSTANCE_ID
1077: from MSC_ST_DESIGNATORS MSD
1078: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1079: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES;
1080:
1081: CURSOR c1 IS

Line 1106: FROM MSC_ST_DESIGNATORS msd,

1102: msd.REFRESH_ID,
1103: msd.SR_INSTANCE_ID,
1104: msd.DESIGNATOR_TYPE,
1105: null forecast_Set_id
1106: FROM MSC_ST_DESIGNATORS msd,
1107: MSC_TP_ID_LID mtil,
1108: MSC_TP_SITE_ID_LID mtsila,
1109: MSC_TP_SITE_ID_LID mtsilb
1110: WHERE msd.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id

Line 3058: FROM MSC_ST_DESIGNATORS msd

3054: msd.PRODUCTION,
3055: msd.RECOMMENDATION_RELEASE,
3056: msd.DESIGNATOR_TYPE,
3057: msd.SR_INSTANCE_ID
3058: FROM MSC_ST_DESIGNATORS msd
3059: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3060: AND designator_type <> 6;
3061:
3062: c_count NUMBER:= 0;