APPS.MSC_GET_GANTT_DATA dependencies on MSC_DEPARTMENT_RESOURCES

Line 73: from msc_department_resources mdr,

69:
70: CURSOR name IS
71: select mtp.organization_code
72: ||':'||mdr.department_code || ':' || mdr.resource_code
73: from msc_department_resources mdr,
74: msc_trading_partners mtp
75: where mdr.department_id = v_dept_id
76: and mdr.resource_id = v_res_id
77: and mdr.plan_id = p_plan_id

Line 486: from msc_department_resources

482: time_change boolean :=false;
483: v_total_avail number;
484: CURSOR line_rate IS
485: select max_rate
486: from msc_department_resources
487: where organization_id =v_org_id
488: and sr_instance_id = v_instance_id
489: and department_id = v_dept_id
490: and resource_id = v_res_id

Line 1860: msc_department_resources mdr,

1856: nvl(to_char(mrr.ULPSD,format_mask),'null') ULPSD,
1857: nvl(to_char(mrr.ULPCD,format_mask),'null') ULPCD
1858: FROM msc_supplies ms,
1859: msc_resource_requirements mrr,
1860: msc_department_resources mdr,
1861: msc_system_items msi,
1862: msc_process_effectivity pe
1863: WHERE pe.plan_id(+) = ms.plan_id
1864: AND pe.sr_instance_id(+) = ms.sr_instance_id

Line 2329: FROM msc_department_resources mdr,

2325: mdr.resource_id
2326: bulk collect into
2327: v_dept_code,
2328: v_org, v_instance, v_dept, v_res
2329: FROM msc_department_resources mdr,
2330: msc_trading_partners mtp,
2331: msc_form_query mfq
2332: WHERE mdr.plan_id = p_plan_id
2333: AND mdr.organization_id = mfq.number2

Line 2837: msc_department_resources mdr

2833: Begin
2834: select nvl(mdr.batchable_flag, 2)
2835: into v_flag
2836: from msc_resource_requirements mrr,
2837: msc_department_resources mdr
2838: where mrr.plan_id = p_plan_id
2839: and mrr.transaction_id = p_transaction_id
2840: and mrr.sr_instance_id = p_instance_id
2841: AND mdr.plan_id = mrr.plan_id

Line 3221: ' msc_department_resources mdr ' ||

3217: if p_from_block = 'RESOURCE' then
3218: sql_stat := ' SELECT distinct mrr.sr_instance_id, ' ||
3219: ' mrr.supply_id ' ||
3220: ' FROM msc_resource_requirements mrr, ' ||
3221: ' msc_department_resources mdr ' ||
3222: ' WHERE mrr.plan_id = '||p_plan_id ||
3223: ' AND mdr.plan_id = mrr.plan_id '||
3224: ' AND mdr.organization_id = mrr.organization_id ' ||
3225: ' AND mdr.sr_instance_id = mrr.sr_instance_id'||

Line 3314: ' msc_department_resources mdr, ' ||

3310: ' mrr.organization_id, '||
3311: ' mrr.department_id, '||
3312: ' mrr.resource_id '||
3313: ' FROM msc_resource_requirements mrr, ' ||
3314: ' msc_department_resources mdr, ' ||
3315: ' msc_exception_details med ' ||
3316: ' WHERE mrr.plan_id = :1 '||
3317: ' AND mdr.plan_id = mrr.plan_id '||
3318: ' AND mdr.organization_id = mrr.organization_id ' ||

Line 3349: ' msc_department_resources mdr ' ||

3345: ' mrr.organization_id, '||
3346: ' mrr.department_id, '||
3347: ' mrr.resource_id '||
3348: ' FROM msc_resource_requirements mrr, ' ||
3349: ' msc_department_resources mdr ' ||
3350: ' WHERE mrr.plan_id = :1 '||
3351: ' AND mdr.plan_id = mrr.plan_id '||
3352: ' AND mdr.organization_id = mrr.organization_id ' ||
3353: ' AND mdr.sr_instance_id = mrr.sr_instance_id'||

Line 5191: msc_department_resources mdr

5187: nvl(to_char(mrr.ULPSD,format_mask),'null') ULPSD,
5188: nvl(to_char(mrr.ULPCD,format_mask),'null') ULPCD
5189: FROM msc_resource_requirements mrr,
5190: msc_supplies ms,
5191: msc_department_resources mdr
5192: WHERE mrr.plan_id = p_plan_id
5193: AND mrr.transaction_id = p_transaction_id
5194: and mrr.sr_instance_id = p_instance_id
5195: and ms.sr_instance_id = mrr.sr_instance_id