DBA Data[Home] [Help]

APPS.MSC_ASK_ORACLE dependencies on MSC_RESOURCE_REQUIREMENTS

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