DBA Data[Home] [Help]

APPS.MSC_ASK_ORACLE dependencies on MSC_SUPPLIES

Line 413: FROM pjm_tasks_v p2, pa_tasks_v p1, msc_supplies m

409: early_start_date,
410: early_finish_date,late_start_date, late_finish_date,
411: scheduled_start_date, scheduled_finish_date
412: INTO l_prj, l_es, l_ef, l_ls, l_lf, l_ss, l_sf
413: FROM pjm_tasks_v p2, pa_tasks_v p1, msc_supplies m
414: WHERE p2.project_id = p1.project_id
415: AND p2.task_id = p1.task_id
416: AND p1.project_id = m.project_id
417: AND p1.task_id = m.task_id

Line 484: FROM msc_resource_requirements res, msc_supplies sup

480:
481: CURSOR overloaded_res(lkey NUMBER, lplan NUMBER) IS
482: SELECT res.operation_seq_num, res.std_op_code, res.resource_seq_num,
483: res.start_date, res.end_date
484: FROM msc_resource_requirements res, msc_supplies sup
485: WHERE sup.plan_id = lplan
486: AND sup.transaction_id = lkey
487: AND res.plan_id = sup.plan_id
488: AND res.supply_id = sup.transaction_id