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

Line 86: MTL_LOT_NUMBERS mlna ,

82: from PJM_PROJECT_PARAMETERS ppp
83: ,PJM_PROJECTS_ORG_V ppovs
84: ,MTL_ITEM_LOCATIONS mil
85: ,
86: MTL_LOT_NUMBERS mlna ,
87: WMS_TRX_DETAILS_TMP_V mptdtv
88: ,(
89: select msn.current_organization_id organization_id
90: ,msn.inventory_item_id

Line 120: ,mtl_lot_numbers lot

116: ,NULL location_current_units
117: from mtl_serial_numbers msn
118: ,mtl_secondary_inventories sub
119: ,mtl_item_locations loc
120: ,mtl_lot_numbers lot
121: where msn.current_status = 3
122: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
123: decode(g_unit_number, '-9999', 'a', g_unit_number)
124: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 184: MTL_LOT_NUMBERS mlna ,

180: from PJM_PROJECT_PARAMETERS ppp
181: ,PJM_PROJECTS_ORG_V ppovs
182: ,MTL_ITEM_LOCATIONS mil
183: ,
184: MTL_LOT_NUMBERS mlna ,
185: WMS_TRX_DETAILS_TMP_V mptdtv
186: ,(
187: select msn.current_organization_id organization_id
188: ,msn.inventory_item_id

Line 218: ,mtl_lot_numbers lot

214: ,NULL location_current_units
215: from mtl_serial_numbers msn
216: ,mtl_secondary_inventories sub
217: ,mtl_item_locations loc
218: ,mtl_lot_numbers lot
219: where msn.current_status = 3
220: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
221: decode(g_unit_number, '-9999', 'a', g_unit_number)
222: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 298: MTL_LOT_NUMBERS mlna ,

294: from PJM_PROJECT_PARAMETERS ppp
295: ,PJM_PROJECTS_ORG_V ppovs
296: ,MTL_ITEM_LOCATIONS mil
297: ,
298: MTL_LOT_NUMBERS mlna ,
299: WMS_TRX_DETAILS_TMP_V mptdtv
300: ,(
301: select msn.current_organization_id organization_id
302: ,msn.inventory_item_id

Line 332: ,mtl_lot_numbers lot

328: ,NULL location_current_units
329: from mtl_serial_numbers msn
330: ,mtl_secondary_inventories sub
331: ,mtl_item_locations loc
332: ,mtl_lot_numbers lot
333: where msn.current_status = 3
334: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
335: decode(g_unit_number, '-9999', 'a', g_unit_number)
336: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 409: MTL_LOT_NUMBERS mlna ,

405: from PJM_PROJECT_PARAMETERS ppp
406: ,PJM_PROJECTS_ORG_V ppovs
407: ,MTL_ITEM_LOCATIONS mil
408: ,
409: MTL_LOT_NUMBERS mlna ,
410: WMS_TRX_DETAILS_TMP_V mptdtv
411: ,(
412: SELECT x.organization_id organization_id
413: ,x.inventory_item_id inventory_item_id

Line 498: ,mtl_lot_numbers lot

494: HAVING
495: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
496: ) x
497: ,mtl_secondary_inventories sub
498: ,mtl_lot_numbers lot
499: where
500: -- x.primary_quantity > 0 and -- high volume project 8546026
501: x.organization_id = sub.organization_id
502: and x.subinventory_code = sub.secondary_inventory_name