DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on MTL_SYSTEM_ITEMS

Line 309: mtl_system_items msi,

305: (1 - (NVL(FND_PROFILE.Value_Specific('MRP_BIS_AV_DISCOUNT'),0)/100)),
306: NVL(-spl.rounding_factor,2))
307: into arg_price
308: from oe_price_list_lines sopl,
309: mtl_system_items msi,
310: oe_price_lists spl
311: where spl.price_list_id = FND_PROFILE.Value_Specific('MRP_BIS_PRICE_LIST')
312: and sopl.price_list_id = spl.price_list_id
313: and sopl.inventory_item_id = arg_item_id

Line 343: mtl_system_items msi,

339:
340: select round(list_price,NVL(spl.rounding_factor,2))
341: into arg_price
342: from oe_price_list_lines sopl,
343: mtl_system_items msi,
344: oe_price_lists spl
345: where spl.price_list_id = arg_price_list_id
346: and sopl.price_list_id = spl.price_list_id
347: and sopl.inventory_item_id = arg_item_id

Line 703: mtl_system_items_kfv sys3,

699: mtl_categories_vl vcat,
700: mtl_item_categories icat,
701: bom_calendar_dates cal,
702: mtl_parameters mp,
703: mtl_system_items_kfv sys3,
704: mtl_system_items_kfv sys2,
705: mtl_system_items_kfv sys,
706: (SELECT inventory_item_id,
707: ship_from_org_id organization_id,

Line 704: mtl_system_items_kfv sys2,

700: mtl_item_categories icat,
701: bom_calendar_dates cal,
702: mtl_parameters mp,
703: mtl_system_items_kfv sys3,
704: mtl_system_items_kfv sys2,
705: mtl_system_items_kfv sys,
706: (SELECT inventory_item_id,
707: ship_from_org_id organization_id,
708: schedule_ship_date requirement_date,

Line 705: mtl_system_items_kfv sys,

701: bom_calendar_dates cal,
702: mtl_parameters mp,
703: mtl_system_items_kfv sys3,
704: mtl_system_items_kfv sys2,
705: mtl_system_items_kfv sys,
706: (SELECT inventory_item_id,
707: ship_from_org_id organization_id,
708: schedule_ship_date requirement_date,
709: sold_to_org_id customer_id,

Line 1000: mtl_system_items_kfv sys3,

996: mtl_categories_vl vcat,
997: mtl_item_categories icat,
998: bom_calendar_dates cal,
999: mtl_parameters mp,
1000: mtl_system_items_kfv sys3,
1001: mtl_system_items_kfv sys2,
1002: mtl_system_items_kfv sys,
1003: mrp_forecast_designators desig,
1004: mrp_forecast_dates dates

Line 1001: mtl_system_items_kfv sys2,

997: mtl_item_categories icat,
998: bom_calendar_dates cal,
999: mtl_parameters mp,
1000: mtl_system_items_kfv sys3,
1001: mtl_system_items_kfv sys2,
1002: mtl_system_items_kfv sys,
1003: mrp_forecast_designators desig,
1004: mrp_forecast_dates dates
1005: WHERE PART.party_id (+) = CA.party_id

Line 1002: mtl_system_items_kfv sys,

998: bom_calendar_dates cal,
999: mtl_parameters mp,
1000: mtl_system_items_kfv sys3,
1001: mtl_system_items_kfv sys2,
1002: mtl_system_items_kfv sys,
1003: mrp_forecast_designators desig,
1004: mrp_forecast_dates dates
1005: WHERE PART.party_id (+) = CA.party_id
1006: AND org.organization_id = desig.organization_id

Line 1200: mtl_system_items_kfv sys3,

1196: mtl_category_sets scat,
1197: mtl_categories_kfv cat,
1198: mtl_categories_vl vcat,
1199: mtl_item_categories icat,
1200: mtl_system_items_kfv sys3,
1201: mtl_system_items_kfv sys2,
1202: mtl_system_items_kfv sys,
1203: mtl_parameters param,
1204: (SELECT distinct organization_id, organization_code, organization_name,

Line 1201: mtl_system_items_kfv sys2,

1197: mtl_categories_kfv cat,
1198: mtl_categories_vl vcat,
1199: mtl_item_categories icat,
1200: mtl_system_items_kfv sys3,
1201: mtl_system_items_kfv sys2,
1202: mtl_system_items_kfv sys,
1203: mtl_parameters param,
1204: (SELECT distinct organization_id, organization_code, organization_name,
1205: update_type, forecast_set, inventory_item_id

Line 1202: mtl_system_items_kfv sys,

1198: mtl_categories_vl vcat,
1199: mtl_item_categories icat,
1200: mtl_system_items_kfv sys3,
1201: mtl_system_items_kfv sys2,
1202: mtl_system_items_kfv sys,
1203: mtl_parameters param,
1204: (SELECT distinct organization_id, organization_code, organization_name,
1205: update_type, forecast_set, inventory_item_id
1206: FROM mrp_bis_forecast_wb