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_EXP_WF dependencies on MSC_DEMANDS

Line 162: msc_demands md2,

158: exp.number1,
159: exp.number2
160: FROM msc_supplies sup,
161: msc_full_pegging mfp,
162: msc_demands md2,
163: msc_demands md,
164: msc_exception_details exp,
165: msc_system_items mi,
166: msc_trading_partners mtp,

Line 163: msc_demands md,

159: exp.number2
160: FROM msc_supplies sup,
161: msc_full_pegging mfp,
162: msc_demands md2,
163: msc_demands md,
164: msc_exception_details exp,
165: msc_system_items mi,
166: msc_trading_partners mtp,
167: mfg_lookups ml,

Line 335: msc_demands md2,

331: exp.number1,
332: exp.number2
333: FROM msc_supplies sup,
334: msc_full_pegging mfp,
335: msc_demands md2,
336: msc_demands md,
337: msc_exception_details exp,
338: msc_system_items mi,
339: msc_trading_partners mtp,

Line 336: msc_demands md,

332: exp.number2
333: FROM msc_supplies sup,
334: msc_full_pegging mfp,
335: msc_demands md2,
336: msc_demands md,
337: msc_exception_details exp,
338: msc_system_items mi,
339: msc_trading_partners mtp,
340: mfg_lookups ml,

Line 510: msc_demands md2,

506: exp.number1,
507: exp.number2
508: FROM msc_supplies sup,
509: msc_full_pegging mfp,
510: msc_demands md2,
511: msc_demands md,
512: msc_exception_details exp,
513: msc_system_items mi,
514: msc_trading_partners mtp,

Line 511: msc_demands md,

507: exp.number2
508: FROM msc_supplies sup,
509: msc_full_pegging mfp,
510: msc_demands md2,
511: msc_demands md,
512: msc_exception_details exp,
513: msc_system_items mi,
514: msc_trading_partners mtp,
515: mfg_lookups ml,

Line 581: msc_demands rec,

577: p_plan_id in number) IS
578: SELECT vend.partner_id,
579: vend.partner_name
580: FROM msc_trading_partners vend,
581: msc_demands rec,
582: msc_exception_details exp
583: WHERE vend.sr_tp_id = rec.customer_id
584: AND vend.sr_instance_id = rec.sr_instance_id
585: AND vend.partner_type = 2

Line 1063: from msc_demands md,

1059: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
1060: md.demand_id,
1061: md.latest_acceptable_date,
1062: msc_get_name.lookup_meaning('SYS_YES_NO',md.atp_override_flag) atp_override_flag
1063: from msc_demands md,
1064: msc_exception_details med
1065: where med.plan_id = md.plan_id
1066: and med.number1 = md.demand_id
1067: and med.sr_instance_id = md.sr_instance_id

Line 1154: msc_demands

1150: nvl(sum(using_requirement_quantity),0)
1151: into
1152: lv_req_quantity
1153: from
1154: msc_demands
1155: where
1156: organization_id=lv_organization_id
1157: and inventory_item_id=lv_inventory_item_id
1158: and plan_id=p_plan_id

Line 1215: msc_demands

1211: nvl(sum(using_requirement_quantity),0)
1212: into
1213: lv_req_quantity
1214: from
1215: msc_demands
1216: where
1217: organization_id=lv_organization_id
1218: and inventory_item_id=lv_inventory_item_id
1219: and plan_id=p_plan_id

Line 2494: msc_demands mgr,

2490: CURSOR SALESREP_C(p_exception_id in number,
2491: p_plan_id in number) IS
2492: SELECT so.salesrep_id
2493: FROM msc_sales_orders so,
2494: msc_demands mgr,
2495: msc_exception_details exp
2496: WHERE so.sales_order_number = mgr.order_number
2497: AND so.sr_instance_id = mgr.sr_instance_id
2498: AND mgr.plan_id = exp.plan_id

Line 2507: msc_demands mgr

2503: CURSOR SALESREP_C2(p_demand_id in number,
2504: p_plan_id in number) IS
2505: SELECT so.salesrep_id
2506: FROM msc_sales_orders so,
2507: msc_demands mgr
2508: WHERE so.sales_order_number = mgr.order_number
2509: AND so.sr_instance_id = mgr.sr_instance_id
2510: AND mgr.plan_id = p_plan_id
2511: AND mgr.demand_id = p_demand_id;

Line 2515: FROM msc_partner_contacts cont, msc_demands mgr,

2511: AND mgr.demand_id = p_demand_id;
2512:
2513: CURSOR CUSTCNT_C(p_exception_id in number, p_plan_id in number) IS
2514: SELECT name
2515: FROM msc_partner_contacts cont, msc_demands mgr,
2516: msc_exception_details exp
2517: WHERE exp.exception_detail_id = p_exception_id
2518: AND exp.plan_id = p_plan_id
2519: AND cont.partner_id = mgr.customer_id

Line 2528: FROM msc_partner_contacts cont, msc_demands mgr

2524: AND mgr.plan_id = exp.plan_id;
2525:
2526: CURSOR CUSTCNT_C2(p_demand_id in number, p_plan_id in number) IS
2527: SELECT name
2528: FROM msc_partner_contacts cont, msc_demands mgr
2529: where cont.partner_id = mgr.customer_id
2530: AND cont.partner_site_id = mgr.customer_site_id
2531: AND cont.partner_type = 2
2532: and cont.sr_instance_id = mgr.sr_instance_id

Line 3647: FROM msc_demands

3643: p_inst_id number,
3644: p_demand_id NUMBER) return number is
3645: CURSOR dmd_cur IS
3646: SELECT origination_type
3647: FROM msc_demands
3648: WHERE plan_id = p_plan_id
3649: and sr_instance_id = p_inst_id
3650: and demand_id = p_demand_id;
3651: p_order_type number;

Line 3668: FROM msc_demands

3664: p_inst_id number,
3665: p_demand_id NUMBER) return date is
3666: CURSOR dmd_cur IS
3667: SELECT using_assembly_demand_date
3668: FROM msc_demands
3669: WHERE plan_id = p_plan_id
3670: and sr_instance_id = p_inst_id
3671: and demand_id = p_demand_id;
3672: p_order_date date;

Line 3690: FROM msc_demands

3686: p_inst_id number,
3687: p_demand_id NUMBER) return date is
3688: CURSOR dmd_cur IS
3689: SELECT DMD_SATISFIED_DATE
3690: FROM msc_demands
3691: WHERE plan_id = p_plan_id
3692: and sr_instance_id = p_inst_id
3693: and demand_id = p_demand_id;
3694: p_supply_date date;