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

Line 1951: FROM msc_full_pegging mfp1,

1947: sum(nvl(mfp1.allocated_quantity,0)),
1948: mfp2.demand_quantity,
1949: mfp2.demand_date,
1950: mfp2.inventory_item_id
1951: FROM msc_full_pegging mfp1,
1952: msc_full_pegging mfp2
1953: WHERE mfp1.plan_id = p_plan_id
1954: AND mfp1.organization_id = v_org_id
1955: AND mfp1.sr_instance_id = p_instance_id

Line 1952: msc_full_pegging mfp2

1948: mfp2.demand_quantity,
1949: mfp2.demand_date,
1950: mfp2.inventory_item_id
1951: FROM msc_full_pegging mfp1,
1952: msc_full_pegging mfp2
1953: WHERE mfp1.plan_id = p_plan_id
1954: AND mfp1.organization_id = v_org_id
1955: AND mfp1.sr_instance_id = p_instance_id
1956: AND mfp1.transaction_id = v_transaction_id

Line 3805: from msc_full_pegging mfp1,

3801: ms.source_organization_id),
3802: mtp.organization_code||':'||msi.item_name,
3803: ms.inventory_item_id,
3804: nvl(ms.supplier_id,-1)
3805: from msc_full_pegging mfp1,
3806: msc_full_pegging mfp2,
3807: msc_supplies ms,
3808: msc_system_items msi,
3809: msc_trading_partners mtp,

Line 3806: msc_full_pegging mfp2,

3802: mtp.organization_code||':'||msi.item_name,
3803: ms.inventory_item_id,
3804: nvl(ms.supplier_id,-1)
3805: from msc_full_pegging mfp1,
3806: msc_full_pegging mfp2,
3807: msc_supplies ms,
3808: msc_system_items msi,
3809: msc_trading_partners mtp,
3810: msc_form_query mfq

Line 4010: from msc_full_pegging mfp

4006: sysdate,
4007: -1,
4008: -1,
4009: mfp.end_pegging_id
4010: from msc_full_pegging mfp
4011: where mfp.plan_id = p_plan_id
4012: and mfp.demand_id = g_end_demand_id;
4013:
4014: end if;

Line 4190: from msc_full_pegging mfp

4186: sysdate,
4187: -1,
4188: -1,
4189: mfp.end_pegging_id
4190: from msc_full_pegging mfp
4191: where mfp.plan_id = p_plan_id
4192: and mfp.transaction_id = p_end_supply_id;
4193: end if;
4194:

Line 4276: from msc_full_pegging mfp1,

4272: ms.organization_id,
4273: ms.source_organization_id),
4274: ms.inventory_item_id,
4275: nvl(ms.supplier_id,-1)
4276: from msc_full_pegging mfp1,
4277: msc_full_pegging mfp2,
4278: msc_supplies ms,
4279: msc_demands md,
4280: msc_system_items msi,

Line 4277: msc_full_pegging mfp2,

4273: ms.source_organization_id),
4274: ms.inventory_item_id,
4275: nvl(ms.supplier_id,-1)
4276: from msc_full_pegging mfp1,
4277: msc_full_pegging mfp2,
4278: msc_supplies ms,
4279: msc_demands md,
4280: msc_system_items msi,
4281: msc_critical_paths mcp,

Line 4396: from msc_full_pegging mfp1,

4392: ms.organization_id,
4393: ms.source_organization_id),
4394: ms.inventory_item_id,
4395: nvl(ms.supplier_id,-1)
4396: from msc_full_pegging mfp1,
4397: msc_full_pegging mfp2,
4398: msc_system_items msi,
4399: msc_supplies ms,
4400: msc_demands md,

Line 4397: msc_full_pegging mfp2,

4393: ms.source_organization_id),
4394: ms.inventory_item_id,
4395: nvl(ms.supplier_id,-1)
4396: from msc_full_pegging mfp1,
4397: msc_full_pegging mfp2,
4398: msc_system_items msi,
4399: msc_supplies ms,
4400: msc_demands md,
4401: msc_form_query mfq

Line 4817: from msc_full_pegging mfp1,

4813: msc_get_gantt_data.supplyType(ms.order_type,
4814: msi.planning_make_buy_code,
4815: ms.organization_id,
4816: ms.source_organization_id)
4817: from msc_full_pegging mfp1,
4818: msc_full_pegging mfp2,
4819: msc_form_query mfq,
4820: msc_supplies ms,
4821: msc_system_items msi,

Line 4818: msc_full_pegging mfp2,

4814: msi.planning_make_buy_code,
4815: ms.organization_id,
4816: ms.source_organization_id)
4817: from msc_full_pegging mfp1,
4818: msc_full_pegging mfp2,
4819: msc_form_query mfq,
4820: msc_supplies ms,
4821: msc_system_items msi,
4822: msc_trading_partners mtp

Line 4866: from msc_full_pegging mfp2,

4862: msc_get_gantt_data.supplyType(ms.order_type,
4863: msi.planning_make_buy_code,
4864: ms.organization_id,
4865: ms.source_organization_id)
4866: from msc_full_pegging mfp2,
4867: msc_form_query mfq,
4868: msc_supplies ms,
4869: msc_system_items msi,
4870: msc_trading_partners mtp

Line 5213: from msc_full_pegging mfp

5209:
5210: cursor alloc_cur is
5211: select sum(decode(mfp.demand_id, -1, mfp.allocated_quantity, 0)),
5212: sum(mfp.allocated_quantity)
5213: from msc_full_pegging mfp
5214: where mfp.plan_id = p_plan_id
5215: AND mfp.transaction_id = p_transaction_id
5216: and mfp.end_pegging_id = p_end_peg_id;
5217:

Line 5230: from msc_full_pegging mfp

5226: -- calculate alloc_qty, excess_qty, and short_qty
5227:
5228: select mfp.end_pegging_id
5229: bulk collect into v_end_peg_id
5230: from msc_full_pegging mfp
5231: where mfp.plan_id = p_plan_id
5232: and mfp.demand_id = g_end_demand_id
5233: and mfp.pegging_id = mfp.end_pegging_id;
5234: for a in 1..v_end_peg_id.count loop

Line 5782: from msc_full_pegging mfp,

5778: ms.source_organization_id),
5779: mtp.organization_code ||':'||msi.item_name,
5780: ms.inventory_item_id,
5781: nvl(ms.supplier_id,-1)
5782: from msc_full_pegging mfp,
5783: msc_supplies ms,
5784: msc_system_items msi,
5785: msc_trading_partners mtp
5786: where mfp.demand_id = p_demand_id

Line 6327: msc_full_pegging mfp2,

6323: p_transaction_id number) return number is
6324: CURSOR dmd_cur IS
6325: SELECT min(md.demand_priority)
6326: FROM msc_demands md,
6327: msc_full_pegging mfp2,
6328: msc_full_pegging mfp1
6329: WHERE mfp1.plan_id = p_plan_id
6330: and mfp1.transaction_id = p_transaction_id
6331: and mfp1.sr_instance_id = p_instance_id

Line 6328: msc_full_pegging mfp1

6324: CURSOR dmd_cur IS
6325: SELECT min(md.demand_priority)
6326: FROM msc_demands md,
6327: msc_full_pegging mfp2,
6328: msc_full_pegging mfp1
6329: WHERE mfp1.plan_id = p_plan_id
6330: and mfp1.transaction_id = p_transaction_id
6331: and mfp1.sr_instance_id = p_instance_id
6332: and mfp2.pegging_id = mfp1.end_pegging_id