DBA Data[Home] [Help]

APPS.MSC_SNAPSHOT_PK dependencies on MSC_PLAN_SCHEDULES

Line 696: from msc_plan_schedules_v

692: BEGIN
693:
694: select count(*)
695: into lv_global_forecast
696: from msc_plan_schedules_v
697: where plan_id = p_plan_id
698: and input_organization_id = GLOBAL_ORG;
699:
700: EXCEPTION WHEN OTHERS THEN

Line 2067: MSC_PLAN_SCHEDULES mpsv

2063: mdsm.LAST_UPDATED_BY LAST_UPDATED_BY,
2064: mdsm.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
2065: FROM
2066: MSC_DMD_SCN_METRICS mdsm,
2067: MSC_PLAN_SCHEDULES mpsv
2068: WHERE
2069: -1 = mdsm.plan_id
2070: AND mpsv.input_schedule_id = mdsm.scenario_id
2071: AND mpsv.organization_id = mdsm.organization_id