DBA Data[Home] [Help]

APPS.MSC_PQ_UTILS dependencies on MSC_RESOURCE_REQUIREMENTS

Line 366: FROM msc_resource_requirements

362: p_org_id NUMBER,
363: p_dept_id NUMBER,
364: p_res_id NUMBER) IS
365: SELECT supply_id
366: FROM msc_resource_requirements
367: WHERE plan_id = p_plan_id
368: AND sr_instance_id = p_inst_id
369: AND organization_id = p_org_id
370: AND department_id = p_dept_id

Line 382: FROM msc_resource_requirements

378: p_supply_id NUMBER,
379: p_op_seq NUMBER,
380: p_res_seq NUMBER) IS
381: SELECT supply_id,transaction_id
382: FROM msc_resource_requirements
383: WHERE plan_id = p_plan_id
384: AND sr_instance_id = p_inst_id
385: AND organization_id = p_org_id
386: AND department_id = p_dept_id

Line 401: FROM msc_resource_requirements

397: p_res_id NUMBER,
398: p_from_date DATE,
399: p_to_date DATE) IS
400: SELECT supply_id
401: FROM msc_resource_requirements
402: WHERE plan_id = p_plan_id
403: AND sr_instance_id = p_inst_id
404: AND organization_id = p_org_id
405: AND department_id = p_dept_id

Line 423: FROM msc_resource_requirements r,

419: p_res_id NUMBER,
420: p_from_date DATE,
421: p_to_date DATE) IS
422: SELECT supply_id
423: FROM msc_resource_requirements r,
424: msc_supplies s,
425: msc_system_items i
426: WHERE r.plan_id = p_plan_id
427: AND r.sr_instance_id = p_inst_id