APPS.MSC_EXP_WF dependencies on MSC_SYSTEM_ITEMS

Line 8: msc_system_items sys

4: CURSOR PLANNER_C( p_plan_id in number, p_inventory_item_id in number,
5: p_organization_id in number, p_instance_id in number) IS
6: SELECT distinct pl.user_name
7: FROM msc_planners pl,
8: msc_system_items sys
9: WHERE sys.plan_id = p_plan_id
10: AND sys.organization_id = p_organization_id
11: AND sys.sr_instance_id = p_instance_id
12: AND sys.inventory_item_id = p_inventory_item_id

Line 165: msc_system_items mi,

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,
168: mfg_lookups sup_ml
169: WHERE exp.exception_type in

Line 338: msc_system_items mi,

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,
341: mfg_lookups sup_ml
342: WHERE exp.exception_type in

Line 513: msc_system_items mi,

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,
516: mfg_lookups sup_ml
517: WHERE exp.exception_type in

Line 1037: from msc_system_items msi

1033: lv_pab NUMBER := 0;--Projected available balance
1034:
1035: CURSOR LEADTIME_C IS
1036: select nvl(PREPROCESSING_LEAD_TIME,0),nvl(FIXED_LEAD_TIME,0),nvl(POSTPROCESSING_LEAD_TIME,0)
1037: from msc_system_items msi
1038: where msi.sr_instance_id = instance_id
1039: and msi.plan_id = p_plan_id
1040: and msi.organization_id = lv_organization_id
1041: and msi.inventory_item_id = lv_inventory_item_id;

Line 2274: msc_system_items msi, msc_item_suppliers sup

2270: CURSOR uom(partner_id in number,partner_site_id in number,
2271: item_id in number, org_id in number, inst_id in number) IS
2272: SELECT DISTINCT convd.conversion_rate/convs.conversion_rate
2273: FROM msc_uom_conversions convs,msc_uom_conversions convd,
2274: msc_system_items msi, msc_item_suppliers sup
2275: WHERE sup.supplier_id = partner_id
2276: AND sup.supplier_site_id = partner_site_id
2277: AND sup.inventory_item_id = item_id
2278: AND sup.organization_id = org_id

Line 2462: FROM msc_partner_contacts cont, msc_system_items sys

2458: p_plan_id in number,
2459: p_org_id in number,
2460: p_instance in number) IS
2461: SELECT cont.name
2462: FROM msc_partner_contacts cont, msc_system_items sys
2463: WHERE sys.inventory_item_id = p_inventory_item_id
2464: AND sys.organization_id = p_org_id
2465: AND sys.sr_instance_id = p_instance
2466: AND sys.plan_id = p_plan_id