APPS.MSC_EXP_WF dependencies on MSC_SUPPLIES

Line 160: FROM msc_supplies sup,

156: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),
157: decode(exp.exception_type, 37, exp.number4,null),
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,

Line 333: FROM msc_supplies sup,

329: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),
330: decode(exp.exception_type, 37, exp.number4,null),
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,

Line 508: FROM msc_supplies sup,

504: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),
505: decode(exp.exception_type, 37, exp.number4,null),
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,

Line 550: msc_supplies ms

546: SELECT vend.partner_id,
547: vend.partner_name
548: FROM msc_trading_partners vend,
549: msc_exception_details exp,
550: msc_supplies ms
551: WHERE vend.partner_id = nvl(exp.supplier_id, ms.supplier_id)
552: AND vend.partner_type = 1
553: AND ms.plan_id (+) = exp.plan_id
554: AND ms.transaction_id (+) = exp.number1

Line 567: msc_supplies ms

563: site.tp_site_code
564: FROM msc_trading_partners vend,
565: msc_trading_partner_sites site,
566: msc_exception_details exp,
567: msc_supplies ms
568: WHERE site.partner_site_id = nvl(exp.supplier_site_id,ms.supplier_site_id)
569: AND vend.partner_id = nvl(exp.supplier_id, ms.supplier_id)
570: AND vend.partner_type = 1
571: AND ms.plan_id (+) = exp.plan_id

Line 1120: msc_supplies

1116: nvl(sum(new_order_quantity),0)
1117: into
1118: lv_ava_quantity
1119: from
1120: msc_supplies
1121: where
1122: organization_id=lv_organization_id
1123: and inventory_item_id=lv_inventory_item_id
1124: and plan_id=p_plan_id

Line 1137: msc_supplies

1133: nvl(sum(new_order_quantity*(-1)),0)
1134: into
1135: lv_ava_quantity_temp
1136: from
1137: msc_supplies
1138: where
1139: organization_id=lv_organization_id
1140: and inventory_item_id=lv_inventory_item_id
1141: and plan_id=p_plan_id

Line 1179: msc_supplies

1175: nvl(sum(new_order_quantity),0)
1176: into
1177: lv_ava_quantity
1178: from
1179: msc_supplies
1180: where
1181: organization_id=lv_organization_id
1182: and inventory_item_id=lv_inventory_item_id
1183: and plan_id=p_plan_id

Line 1197: msc_supplies

1193: nvl(sum(new_order_quantity*(-1)),0)
1194: into
1195: lv_ava_quantity_temp
1196: from
1197: msc_supplies
1198: where
1199: organization_id=lv_organization_id
1200: and inventory_item_id=lv_inventory_item_id
1201: and plan_id=p_plan_id

Line 2055: UPDATE MSC_SUPPLIES

2051: p_res_po_count number :=0;
2052: p_request_id number;
2053: BEGIN
2054:
2055: UPDATE MSC_SUPPLIES
2056: SET old_order_quantity = new_order_quantity,
2057: quantity_in_process = new_order_quantity,
2058: implement_date = new_schedule_date,
2059: implement_dock_date = new_dock_date,

Line 2475: msc_supplies ms

2471: CURSOR SUPCNT_C(p_exception_id in number,p_plan_id in number) IS
2472: SELECT name
2473: FROM msc_partner_contacts cont,
2474: msc_exception_details exp,
2475: msc_supplies ms
2476: WHERE exp.exception_detail_id = p_exception_id
2477: AND exp.plan_id = p_plan_id
2478: AND cont.partner_site_id = nvl(exp.supplier_site_id,ms.supplier_site_id)
2479: AND cont.partner_type = 1