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_17 dependencies on MTL_LOT_NUMBERS

Line 85: MTL_LOT_NUMBERS mlna ,

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

Line 119: ,mtl_lot_numbers lot

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

Line 180: MTL_LOT_NUMBERS mlna ,

176: ,NULL order_by_string
177: from PJM_PROJECTS_ORG_V ppovs
178: ,MTL_ITEM_LOCATIONS mil
179: ,
180: MTL_LOT_NUMBERS mlna ,
181: WMS_TRX_DETAILS_TMP_V mptdtv
182: ,(
183: select msn.current_organization_id organization_id
184: ,msn.inventory_item_id

Line 214: ,mtl_lot_numbers lot

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

Line 291: MTL_LOT_NUMBERS mlna ,

287: ,NULL order_by_string
288: from PJM_PROJECTS_ORG_V ppovs
289: ,MTL_ITEM_LOCATIONS mil
290: ,
291: MTL_LOT_NUMBERS mlna ,
292: WMS_TRX_DETAILS_TMP_V mptdtv
293: ,(
294: select msn.current_organization_id organization_id
295: ,msn.inventory_item_id

Line 325: ,mtl_lot_numbers lot

321: ,NULL location_current_units
322: from mtl_serial_numbers msn
323: ,mtl_secondary_inventories sub
324: ,mtl_item_locations loc
325: ,mtl_lot_numbers lot
326: where msn.current_status = 3
327: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
328: decode(g_unit_number, '-9999', 'a', g_unit_number)
329: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 399: MTL_LOT_NUMBERS mlna ,

395: ,NULL order_by_string
396: from PJM_PROJECTS_ORG_V ppovs
397: ,MTL_ITEM_LOCATIONS mil
398: ,
399: MTL_LOT_NUMBERS mlna ,
400: WMS_TRX_DETAILS_TMP_V mptdtv
401: ,(
402: SELECT x.organization_id organization_id
403: ,x.inventory_item_id inventory_item_id

Line 488: ,mtl_lot_numbers lot

484: HAVING
485: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
486: ) x
487: ,mtl_secondary_inventories sub
488: ,mtl_lot_numbers lot
489: where
490: -- x.primary_quantity > 0 and -- high volume project 8546026
491: x.organization_id = sub.organization_id
492: and x.subinventory_code = sub.secondary_inventory_name