eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GANTT_PKG dependencies on MSC_FULL_PEGGING

Line 138: msc_full_pegging mfp1

134: md.organization_id,
135: md.demand_id,
136: md.using_assembly_demand_date start_date
137: from msc_demands md,
138: msc_full_pegging mfp1
139: where mfp1.plan_id = x_plan_id
140: and mfp1.transaction_id = x_supply_id
141: and mfp1.sr_instance_id = x_instance_id
142: and mfp1.plan_id = md.plan_id

Line 155: from msc_full_pegging mfp,

151: ms.organization_id,
152: ms.transaction_id,
153: msc_gantt_utils.isCriticalSupply(x_plan_id, g_end_demand_id,
154: ms.transaction_id, ms.sr_instance_id) critical_supply
155: from msc_full_pegging mfp,
156: msc_supplies ms
157: where mfp.demand_id = x_demand_id
158: and mfp.plan_id = x_plan_id
159: and ms.plan_id = mfp.plan_id

Line 311: from msc_full_pegging mfp1,

307: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
308: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
309: ms.source_supplier_id) start_date,
310: ms.order_type
311: from msc_full_pegging mfp1,
312: msc_full_pegging mfp2,
313: msc_form_query mfq,
314: msc_supplies ms,
315: msc_system_items msi

Line 312: msc_full_pegging mfp2,

308: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
309: ms.source_supplier_id) start_date,
310: ms.order_type
311: from msc_full_pegging mfp1,
312: msc_full_pegging mfp2,
313: msc_form_query mfq,
314: msc_supplies ms,
315: msc_system_items msi
316: where mfp1.plan_id = x_plan_id

Line 357: from msc_full_pegging mfp1,

353: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
354: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
355: ms.source_supplier_id) start_date,
356: ms.order_type
357: from msc_full_pegging mfp1,
358: msc_full_pegging mfp2,
359: msc_supplies ms,
360: msc_system_items msi
361: where mfp1.plan_id = x_plan_id

Line 358: msc_full_pegging mfp2,

354: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
355: ms.source_supplier_id) start_date,
356: ms.order_type
357: from msc_full_pegging mfp1,
358: msc_full_pegging mfp2,
359: msc_supplies ms,
360: msc_system_items msi
361: where mfp1.plan_id = x_plan_id
362: and mfp1.sr_instance_id = x_instance_id

Line 393: from msc_full_pegging mfp1,

389: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
390: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
391: ms.source_supplier_id) start_date,
392: ms.order_type
393: from msc_full_pegging mfp1,
394: msc_full_pegging mfp2,
395: msc_supplies ms,
396: msc_system_items msi
397: where mfp1.plan_id = x_plan_id

Line 394: msc_full_pegging mfp2,

390: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
391: ms.source_supplier_id) start_date,
392: ms.order_type
393: from msc_full_pegging mfp1,
394: msc_full_pegging mfp2,
395: msc_supplies ms,
396: msc_system_items msi
397: where mfp1.plan_id = x_plan_id
398: and mfp1.sr_instance_id = x_instance_id

Line 454: from msc_full_pegging mfp1,

450: ms.sr_instance_id,
451: ms.organization_id,
452: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
453: ms.transaction_id, ms.sr_instance_id) critical_supply
454: from msc_full_pegging mfp1,
455: msc_full_pegging mfp2,
456: msc_supplies ms,
457: msc_demands md,
458: msc_form_query mfq

Line 455: msc_full_pegging mfp2,

451: ms.organization_id,
452: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
453: ms.transaction_id, ms.sr_instance_id) critical_supply
454: from msc_full_pegging mfp1,
455: msc_full_pegging mfp2,
456: msc_supplies ms,
457: msc_demands md,
458: msc_form_query mfq
459: where mfp1.plan_id = x_plan_id

Line 486: from msc_full_pegging mfp1,

482: ms.sr_instance_id,
483: ms.organization_id,
484: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
485: ms.transaction_id, ms.sr_instance_id) critical_supply
486: from msc_full_pegging mfp1,
487: msc_full_pegging mfp2,
488: msc_supplies ms,
489: msc_demands md
490: where mfp1.plan_id = x_plan_id

Line 487: msc_full_pegging mfp2,

483: ms.organization_id,
484: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
485: ms.transaction_id, ms.sr_instance_id) critical_supply
486: from msc_full_pegging mfp1,
487: msc_full_pegging mfp2,
488: msc_supplies ms,
489: msc_demands md
490: where mfp1.plan_id = x_plan_id
491: and mfp1.transaction_id = x_supply_id

Line 2670: from msc_full_pegging mfp2,

2666: (query_id, last_update_date, last_updated_by, creation_date, created_by,
2667: last_update_login, number1, number2)
2668: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2669: mfp2.demand_id, mfp2.sr_instance_id
2670: from msc_full_pegging mfp2,
2671: msc_full_pegging mfp,
2672: msc_resource_requirements mrr,
2673: msc_form_query mfq
2674: where mfq.query_id = v_mfq_from_query_id

Line 2671: msc_full_pegging mfp,

2667: last_update_login, number1, number2)
2668: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2669: mfp2.demand_id, mfp2.sr_instance_id
2670: from msc_full_pegging mfp2,
2671: msc_full_pegging mfp,
2672: msc_resource_requirements mrr,
2673: msc_form_query mfq
2674: where mfq.query_id = v_mfq_from_query_id
2675: and mrr.plan_id = p_plan_id

Line 2690: from msc_full_pegging mfp2,

2686: (query_id, last_update_date, last_updated_by, creation_date, created_by,
2687: last_update_login, number1, number2)
2688: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2689: mfp2.demand_id, mfp2.sr_instance_id
2690: from msc_full_pegging mfp2,
2691: msc_full_pegging mfp,
2692: msc_resource_instance_reqs mrir,
2693: msc_form_query mfq
2694: where mfq.query_id = v_mfq_from_query_id

Line 2691: msc_full_pegging mfp,

2687: last_update_login, number1, number2)
2688: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2689: mfp2.demand_id, mfp2.sr_instance_id
2690: from msc_full_pegging mfp2,
2691: msc_full_pegging mfp,
2692: msc_resource_instance_reqs mrir,
2693: msc_form_query mfq
2694: where mfq.query_id = v_mfq_from_query_id
2695: and mrir.plan_id = p_plan_id

Line 2720: from msc_full_pegging mfp2,

2716: (query_id, last_update_date, last_updated_by, creation_date, created_by,
2717: last_update_login, number1, number2)
2718: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2719: mfp2.demand_id, mfp2.sr_instance_id
2720: from msc_full_pegging mfp2,
2721: msc_full_pegging mfp,
2722: msc_resource_requirements mrr
2723: where mrr.plan_id = p_plan_id
2724: and mrr.sr_instance_id = l_inst_id

Line 2721: msc_full_pegging mfp,

2717: last_update_login, number1, number2)
2718: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2719: mfp2.demand_id, mfp2.sr_instance_id
2720: from msc_full_pegging mfp2,
2721: msc_full_pegging mfp,
2722: msc_resource_requirements mrr
2723: where mrr.plan_id = p_plan_id
2724: and mrr.sr_instance_id = l_inst_id
2725: and mrr.organization_id = l_org_id

Line 2743: from msc_full_pegging mfp2,

2739: (query_id, last_update_date, last_updated_by, creation_date, created_by,
2740: last_update_login, number1, number2)
2741: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2742: mfp2.demand_id, mfp2.sr_instance_id
2743: from msc_full_pegging mfp2,
2744: msc_full_pegging mfp,
2745: msc_resource_instance_reqs mrir
2746: where mrir.plan_id = p_plan_id
2747: and mrir.sr_instance_id = l_inst_id

Line 2744: msc_full_pegging mfp,

2740: last_update_login, number1, number2)
2741: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2742: mfp2.demand_id, mfp2.sr_instance_id
2743: from msc_full_pegging mfp2,
2744: msc_full_pegging mfp,
2745: msc_resource_instance_reqs mrir
2746: where mrir.plan_id = p_plan_id
2747: and mrir.sr_instance_id = l_inst_id
2748: and mrir.organization_id = l_org_id

Line 2773: from msc_full_pegging mfp2,

2769: (query_id, last_update_date, last_updated_by, creation_date, created_by,
2770: last_update_login, number1, number2)
2771: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2772: mfp2.demand_id, mfp2.sr_instance_id
2773: from msc_full_pegging mfp2,
2774: msc_full_pegging mfp,
2775: msc_resource_requirements mrr,
2776: msc_form_query mfq
2777: where mfq.query_id = v_mfq_from_query_id

Line 2774: msc_full_pegging mfp,

2770: last_update_login, number1, number2)
2771: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2772: mfp2.demand_id, mfp2.sr_instance_id
2773: from msc_full_pegging mfp2,
2774: msc_full_pegging mfp,
2775: msc_resource_requirements mrr,
2776: msc_form_query mfq
2777: where mfq.query_id = v_mfq_from_query_id
2778: and mrr.plan_id = p_plan_id

Line 2793: from msc_full_pegging mfp2,

2789: (query_id, last_update_date, last_updated_by, creation_date, created_by,
2790: last_update_login, number1, number2)
2791: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2792: mfp2.demand_id, mfp2.sr_instance_id
2793: from msc_full_pegging mfp2,
2794: msc_full_pegging mfp,
2795: msc_form_query mfq
2796: where mfq.query_id = v_mfq_from_query_id
2797: and mfp.plan_id = p_plan_id

Line 2794: msc_full_pegging mfp,

2790: last_update_login, number1, number2)
2791: select distinct v_mfq_to_query_id, sysdate, -1, sysdate, -1, -1,
2792: mfp2.demand_id, mfp2.sr_instance_id
2793: from msc_full_pegging mfp2,
2794: msc_full_pegging mfp,
2795: msc_form_query mfq
2796: where mfq.query_id = v_mfq_from_query_id
2797: and mfp.plan_id = p_plan_id
2798: and mfp.sr_instance_id = mfq.number2