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.MRP_HORIZONTAL_PLAN_SC dependencies on MTL_LOT_NUMBERS

Line 2171: mtl_lot_numbers lots,

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,
2175: mrp_plan_organizations_v orgs,

Line 2238: MTL_LOT_NUMBERS mln,

2234: FROM MTL_Onhand_Quantities_detail moq,
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

Line 2315: MTL_LOT_NUMBERS mln,

2311: WHERE msn.Current_Status IN ( 3,5)
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