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 2488: msc_demands mgr,

2484: CURSOR SALESREP_C(p_exception_id in number,
2485: p_plan_id in number) IS
2486: SELECT so.salesrep_id
2487: FROM msc_sales_orders so,
2488: msc_demands mgr,
2489: msc_exception_details exp
2490: WHERE so.sales_order_number = mgr.order_number
2491: AND so.sr_instance_id = mgr.sr_instance_id
2492: AND mgr.plan_id = exp.plan_id

Line 2501: msc_demands mgr

2497: CURSOR SALESREP_C2(p_demand_id in number,
2498: p_plan_id in number) IS
2499: SELECT so.salesrep_id
2500: FROM msc_sales_orders so,
2501: msc_demands mgr
2502: WHERE so.sales_order_number = mgr.order_number
2503: AND so.sr_instance_id = mgr.sr_instance_id
2504: AND mgr.plan_id = p_plan_id
2505: AND mgr.demand_id = p_demand_id;

Line 2509: FROM msc_partner_contacts cont, msc_demands mgr,

2505: AND mgr.demand_id = p_demand_id;
2506:
2507: CURSOR CUSTCNT_C(p_exception_id in number, p_plan_id in number) IS
2508: SELECT name
2509: FROM msc_partner_contacts cont, msc_demands mgr,
2510: msc_exception_details exp
2511: WHERE exp.exception_detail_id = p_exception_id
2512: AND exp.plan_id = p_plan_id
2513: AND cont.partner_id = mgr.customer_id

Line 2522: FROM msc_partner_contacts cont, msc_demands mgr

2518: AND mgr.plan_id = exp.plan_id;
2519:
2520: CURSOR CUSTCNT_C2(p_demand_id in number, p_plan_id in number) IS
2521: SELECT name
2522: FROM msc_partner_contacts cont, msc_demands mgr
2523: where cont.partner_id = mgr.customer_id
2524: AND cont.partner_site_id = mgr.customer_site_id
2525: AND cont.partner_type = 2
2526: and cont.sr_instance_id = mgr.sr_instance_id

Line 3641: FROM msc_demands

3637: p_inst_id number,
3638: p_demand_id NUMBER) return number is
3639: CURSOR dmd_cur IS
3640: SELECT origination_type
3641: FROM msc_demands
3642: WHERE plan_id = p_plan_id
3643: and sr_instance_id = p_inst_id
3644: and demand_id = p_demand_id;
3645: p_order_type number;

Line 3662: FROM msc_demands

3658: p_inst_id number,
3659: p_demand_id NUMBER) return date is
3660: CURSOR dmd_cur IS
3661: SELECT using_assembly_demand_date
3662: FROM msc_demands
3663: WHERE plan_id = p_plan_id
3664: and sr_instance_id = p_inst_id
3665: and demand_id = p_demand_id;
3666: p_order_date date;

Line 3684: FROM msc_demands

3680: p_inst_id number,
3681: p_demand_id NUMBER) return date is
3682: CURSOR dmd_cur IS
3683: SELECT DMD_SATISFIED_DATE
3684: FROM msc_demands
3685: WHERE plan_id = p_plan_id
3686: and sr_instance_id = p_inst_id
3687: and demand_id = p_demand_id;
3688: p_supply_date date;