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 342: from msc_full_pegging mfp

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

Line 1604: msc_full_pegging mfp2,

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

Line 1605: msc_full_pegging mfp1

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

Line 8257: from msc_full_pegging mfp

8253:
8254: cursor alloc_cur is
8255: select sum(decode(mfp.demand_id, -1, mfp.allocated_quantity, 0)),
8256: sum(mfp.allocated_quantity)
8257: from msc_full_pegging mfp
8258: where mfp.plan_id = p_plan_id
8259: AND mfp.transaction_id = p_transaction_id
8260: and mfp.end_pegging_id = p_end_peg_id;
8261:

Line 8275: from msc_full_pegging mfp

8271:
8272: -- calculate alloc_qty, excess_qty, and short_qty
8273: select mfp.end_pegging_id
8274: bulk collect into v_end_peg_id
8275: from msc_full_pegging mfp
8276: where mfp.plan_id = p_plan_id
8277: and mfp.demand_id = p_end_demand_id
8278: and mfp.pegging_id = mfp.end_pegging_id;
8279:

Line 8473: from msc_full_pegging mfp1,

8469: sum(nvl(mfp1.allocated_quantity,0)),
8470: mfp2.demand_quantity,
8471: mfp2.demand_date,
8472: mfp2.inventory_item_id
8473: from msc_full_pegging mfp1,
8474: msc_full_pegging mfp2
8475: where mfp1.plan_id = p_plan_id
8476: and mfp1.organization_id = v_org_id
8477: and mfp1.sr_instance_id = p_instance_id

Line 8474: msc_full_pegging mfp2

8470: mfp2.demand_quantity,
8471: mfp2.demand_date,
8472: mfp2.inventory_item_id
8473: from msc_full_pegging mfp1,
8474: msc_full_pegging mfp2
8475: where mfp1.plan_id = p_plan_id
8476: and mfp1.organization_id = v_org_id
8477: and mfp1.sr_instance_id = p_instance_id
8478: and mfp1.transaction_id = v_transaction_id

Line 9756: from msc_full_pegging mfp1,

9752: cursor c_alloc_qty (p_plan number, p_trx number,
9753: p_mfq_query_id number, p_mgq_query_id number) is
9754: select mgq.row_index,
9755: sum(nvl(mfp1.allocated_quantity,0)) allocated_quantity
9756: from msc_full_pegging mfp1,
9757: msc_full_pegging mfp2,
9758: msc_gantt_query mgq,
9759: msc_form_query mfq
9760: where mfp1.plan_id = p_plan

Line 9757: msc_full_pegging mfp2,

9753: p_mfq_query_id number, p_mgq_query_id number) is
9754: select mgq.row_index,
9755: sum(nvl(mfp1.allocated_quantity,0)) allocated_quantity
9756: from msc_full_pegging mfp1,
9757: msc_full_pegging mfp2,
9758: msc_gantt_query mgq,
9759: msc_form_query mfq
9760: where mfp1.plan_id = p_plan
9761: and mfp1.transaction_id = p_trx

Line 9772: from msc_full_pegging mfp1,

9768: group by mgq.row_index
9769: union all
9770: select mgq.row_index,
9771: nvl(mfp1.allocated_quantity,0) allocated_quantity
9772: from msc_full_pegging mfp1,
9773: msc_gantt_query mgq,
9774: msc_form_query mfq
9775: where mfp1.plan_id = p_plan
9776: and mfp1.transaction_id = p_trx