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_UTILS dependencies on MSC_FULL_PEGGING

Line 341: from msc_full_pegging mfp

337: select
338: p_query_id,
339: sysdate, -1, sysdate, -1,-1,
340: mfp.end_pegging_id
341: from msc_full_pegging mfp
342: where mfp.plan_id = p_plan_id
343: and mfp.demand_id = p_end_demand_id;
344:
345: end populateEndPegsMFQ;

Line 1603: msc_full_pegging mfp2,

1599:
1600: cursor dmd_cur is
1601: select min(md.demand_priority)
1602: from msc_demands md,
1603: msc_full_pegging mfp2,
1604: msc_full_pegging mfp1
1605: where mfp1.plan_id = p_plan_id
1606: and mfp1.transaction_id = p_transaction_id
1607: and mfp1.sr_instance_id = p_instance_id

Line 1604: msc_full_pegging mfp1

1600: cursor dmd_cur is
1601: select min(md.demand_priority)
1602: from msc_demands md,
1603: msc_full_pegging mfp2,
1604: msc_full_pegging mfp1
1605: where mfp1.plan_id = p_plan_id
1606: and mfp1.transaction_id = p_transaction_id
1607: and mfp1.sr_instance_id = p_instance_id
1608: and mfp2.pegging_id = mfp1.end_pegging_id

Line 8252: from msc_full_pegging mfp

8248:
8249: cursor alloc_cur is
8250: select sum(decode(mfp.demand_id, -1, mfp.allocated_quantity, 0)),
8251: sum(mfp.allocated_quantity)
8252: from msc_full_pegging mfp
8253: where mfp.plan_id = p_plan_id
8254: AND mfp.transaction_id = p_transaction_id
8255: and mfp.end_pegging_id = p_end_peg_id;
8256:

Line 8270: from msc_full_pegging mfp

8266:
8267: -- calculate alloc_qty, excess_qty, and short_qty
8268: select mfp.end_pegging_id
8269: bulk collect into v_end_peg_id
8270: from msc_full_pegging mfp
8271: where mfp.plan_id = p_plan_id
8272: and mfp.demand_id = p_end_demand_id
8273: and mfp.pegging_id = mfp.end_pegging_id;
8274:

Line 8468: from msc_full_pegging mfp1,

8464: sum(nvl(mfp1.allocated_quantity,0)),
8465: mfp2.demand_quantity,
8466: mfp2.demand_date,
8467: mfp2.inventory_item_id
8468: from msc_full_pegging mfp1,
8469: msc_full_pegging mfp2
8470: where mfp1.plan_id = p_plan_id
8471: and mfp1.organization_id = v_org_id
8472: and mfp1.sr_instance_id = p_instance_id

Line 8469: msc_full_pegging mfp2

8465: mfp2.demand_quantity,
8466: mfp2.demand_date,
8467: mfp2.inventory_item_id
8468: from msc_full_pegging mfp1,
8469: msc_full_pegging mfp2
8470: where mfp1.plan_id = p_plan_id
8471: and mfp1.organization_id = v_org_id
8472: and mfp1.sr_instance_id = p_instance_id
8473: and mfp1.transaction_id = v_transaction_id

Line 9751: from msc_full_pegging mfp1,

9747: cursor c_alloc_qty (p_plan number, p_trx number,
9748: p_mfq_query_id number, p_mgq_query_id number) is
9749: select mgq.row_index,
9750: sum(nvl(mfp1.allocated_quantity,0)) allocated_quantity
9751: from msc_full_pegging mfp1,
9752: msc_full_pegging mfp2,
9753: msc_gantt_query mgq,
9754: msc_form_query mfq
9755: where mfp1.plan_id = p_plan

Line 9752: msc_full_pegging mfp2,

9748: p_mfq_query_id number, p_mgq_query_id number) is
9749: select mgq.row_index,
9750: sum(nvl(mfp1.allocated_quantity,0)) allocated_quantity
9751: from msc_full_pegging mfp1,
9752: msc_full_pegging mfp2,
9753: msc_gantt_query mgq,
9754: msc_form_query mfq
9755: where mfp1.plan_id = p_plan
9756: and mfp1.transaction_id = p_trx

Line 9767: from msc_full_pegging mfp1,

9763: group by mgq.row_index
9764: union all
9765: select mgq.row_index,
9766: nvl(mfp1.allocated_quantity,0) allocated_quantity
9767: from msc_full_pegging mfp1,
9768: msc_gantt_query mgq,
9769: msc_form_query mfq
9770: where mfp1.plan_id = p_plan
9771: and mfp1.transaction_id = p_trx