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_SERIAL_NUMBERS

Line 2309: FROM MTL_SERIAL_NUMBERS msn,

2305: 1 Lot_Quantity,
2306: masis.compile_designator,
2307: msn.Current_Locator_ID Locator_ID,
2308: msn.Lot_Number
2309: FROM MTL_SERIAL_NUMBERS msn,
2310: mrp_system_items masis
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

Line 2504: MTL_Serial_Numbers_Temp msnt,

2500: to_date(1, 'J') old_date,
2501: NVL(SUM(mmtt.Primary_Quantity ), 0) new_quantity,
2502: 0 old_quantity
2503: FROM PJM_PROJECT_PARAMETERS mpp,
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,

Line 2505: MTL_SERIAL_NUMBERS msn,

2501: NVL(SUM(mmtt.Primary_Quantity ), 0) new_quantity,
2502: 0 old_quantity
2503: FROM PJM_PROJECT_PARAMETERS mpp,
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,