APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ST_DESIGNATORS

Line 1139: from MSC_ST_DESIGNATORS MSD

1135: SELECT
1136: MSD.DESIGNATOR,
1137: MSD.ORGANIZATION_ID,
1138: MSD.SR_INSTANCE_ID
1139: from MSC_ST_DESIGNATORS MSD
1140: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1141: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES;
1142:
1143: CURSOR c1 IS

Line 1168: FROM MSC_ST_DESIGNATORS msd,

1164: msd.REFRESH_ID,
1165: msd.SR_INSTANCE_ID,
1166: msd.DESIGNATOR_TYPE,
1167: null forecast_Set_id
1168: FROM MSC_ST_DESIGNATORS msd,
1169: MSC_TP_ID_LID mtil,
1170: MSC_TP_SITE_ID_LID mtsila,
1171: MSC_TP_SITE_ID_LID mtsilb
1172: WHERE msd.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id

Line 1418: FROM MSC_ST_DESIGNATORS msd

1414: msd.MPS_RELIEF,
1415: msd.INVENTORY_ATP_FLAG,
1416: msd.DISABLE_DATE,
1417: msd.SR_INSTANCE_ID
1418: FROM MSC_ST_DESIGNATORS msd
1419: WHERE msd.DELETED_FLAG = MSC_UTIL.SYS_NO
1420: AND msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1421: AND msd.DESIGNATOR_TYPE in (12,13);
1422:

Line 1428: FROM MSC_ST_DESIGNATORS msd

1424: SELECT msd.DESIGNATOR,
1425: msd.SRC_DESIGNATOR,
1426: msd.ORGANIZATION_ID,
1427: msd.SR_INSTANCE_ID
1428: FROM MSC_ST_DESIGNATORS msd
1429: WHERE msd.deleted_flag = MSC_UTIL.SYS_YES
1430: AND msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1431: AND msd.DESIGNATOR_TYPE in (12,13);
1432:

Line 3416: FROM MSC_ST_DESIGNATORS msd

3412: msd.PRODUCTION,
3413: msd.RECOMMENDATION_RELEASE,
3414: msd.DESIGNATOR_TYPE,
3415: msd.SR_INSTANCE_ID
3416: FROM MSC_ST_DESIGNATORS msd
3417: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3418: AND designator_type NOT IN (6, 12, 13);
3419:
3420: c_count NUMBER:= 0;