APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MTL_ITEM_LOCATIONS

Line 2170: mtl_item_locations mil,

2166: lots.expiration_date old_date,
2167: NVL(SUM(moq.primary_transaction_quantity), 0) new_quantity,
2168: 0 old_quantity
2169: FROM
2170: mtl_item_locations mil,
2171: mtl_lot_numbers lots,
2172: mtl_onhand_quantities_detail moq,
2173: mrp_sub_inventories sub,
2174: mrp_system_items items,

Line 2239: MTL_ITEM_LOCATIONS mil,

2235: mtl_parameters param,
2236: mtl_material_statuses mms,
2237: mrp_system_items masis,
2238: MTL_LOT_NUMBERS mln,
2239: MTL_ITEM_LOCATIONS mil,
2240: PJM_PROJECT_PARAMETERS mpp,
2241: mrp_sub_inventories sub,
2242: mrp_form_query list
2243: WHERE (arg_res_level = 1

Line 2316: MTL_ITEM_LOCATIONS mil,

2312: AND masis.Organization_ID= msn.Current_Organization_ID
2313: AND masis.Inventory_Item_ID= msn.Inventory_Item_ID
2314: AND masis.Effectivity_Control= 2 ) x,
2315: MTL_LOT_NUMBERS mln,
2316: MTL_ITEM_LOCATIONS mil,
2317: PJM_PROJECT_PARAMETERS mpp,
2318: mrp_sub_inventories sub,
2319: mrp_form_query list
2320: WHERE

Line 2371: MTL_ITEM_LOCATIONS mil,

2367: 0 old_quantity
2368: FROM PJM_PROJECT_PARAMETERS mpp,
2369: mrp_system_items masis,
2370: MTL_Material_Transactions_Temp mmtt,
2371: MTL_ITEM_LOCATIONS mil,
2372: mrp_sub_inventories sub,
2373: mrp_form_query list
2374: WHERE
2375: (arg_res_level = 1

Line 2440: MTL_ITEM_LOCATIONS mil,

2436: 0 old_quantity
2437: FROM PJM_PROJECT_PARAMETERS mpp,
2438: mrp_system_items masis,
2439: MTL_Material_Transactions_Temp mmtt,
2440: MTL_ITEM_LOCATIONS mil,
2441: mrp_sub_inventories sub,
2442: mrp_form_query list
2443: WHERE
2444: (arg_res_level = 1

Line 2508: MTL_ITEM_LOCATIONS mil,

2504: MTL_Serial_Numbers_Temp msnt,
2505: MTL_SERIAL_NUMBERS msn,
2506: mrp_system_items masis,
2507: MTL_Material_Transactions_Temp mmtt,
2508: MTL_ITEM_LOCATIONS mil,
2509: mrp_sub_inventories sub,
2510: mrp_form_query list
2511: WHERE
2512: (arg_res_level = 1