DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on MSC_RESOURCE_REQUIREMENTS

Line 362: FROM msc_resource_requirements

358: p_org_id NUMBER,
359: p_dept_id NUMBER,
360: p_res_id NUMBER) IS
361: SELECT supply_id
362: FROM msc_resource_requirements
363: WHERE plan_id = p_plan_id
364: AND sr_instance_id = p_inst_id
365: AND organization_id = p_org_id
366: AND department_id = p_dept_id

Line 378: FROM msc_resource_requirements

374: p_supply_id NUMBER,
375: p_op_seq NUMBER,
376: p_res_seq NUMBER) IS
377: SELECT supply_id,transaction_id
378: FROM msc_resource_requirements
379: WHERE plan_id = p_plan_id
380: AND sr_instance_id = p_inst_id
381: AND organization_id = p_org_id
382: AND department_id = p_dept_id

Line 397: FROM msc_resource_requirements

393: p_res_id NUMBER,
394: p_from_date DATE,
395: p_to_date DATE) IS
396: SELECT supply_id
397: FROM msc_resource_requirements
398: WHERE plan_id = p_plan_id
399: AND sr_instance_id = p_inst_id
400: AND organization_id = p_org_id
401: AND department_id = p_dept_id

Line 419: FROM msc_resource_requirements r,

415: p_res_id NUMBER,
416: p_from_date DATE,
417: p_to_date DATE) IS
418: SELECT supply_id
419: FROM msc_resource_requirements r,
420: msc_supplies s,
421: msc_system_items i
422: WHERE r.plan_id = p_plan_id
423: AND r.sr_instance_id = p_inst_id