[Home] [Help]
78: ,base.secondary_quantity
79: ,base.grade_code
80: ,NULL consist_string
81: ,msn.SERIAL_NUMBER order_by_string
82: from MTL_SERIAL_NUMBERS msn
83: ,MTL_SYSTEM_ITEMS msi
84: ,
85: MTL_LOT_NUMBERS mlna ,
86: WMS_TRX_DETAILS_TMP_V mptdtv
112: ,loc.task_id task_id
113: ,NULL locator_inventory_item_id
114: ,NULL empty_flag
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
176: ,sum(base.secondary_quantity)
177: ,base.grade_code
178: ,NULL consist_string
179: ,msn.SERIAL_NUMBER order_by_string
180: from MTL_SERIAL_NUMBERS msn
181: ,MTL_SYSTEM_ITEMS msi
182: ,
183: MTL_LOT_NUMBERS mlna ,
184: WMS_TRX_DETAILS_TMP_V mptdtv
210: ,loc.task_id task_id
211: ,NULL locator_inventory_item_id
212: ,NULL empty_flag
213: ,NULL location_current_units
214: from mtl_serial_numbers msn
215: ,mtl_secondary_inventories sub
216: ,mtl_item_locations loc
217: ,mtl_lot_numbers lot
218: where msn.current_status = 3
291: ,sum(base.secondary_quantity)
292: ,base.grade_code
293: ,NULL consist_string
294: ,msn.SERIAL_NUMBER order_by_string
295: from MTL_SERIAL_NUMBERS msn
296: ,MTL_SYSTEM_ITEMS msi
297: ,
298: MTL_LOT_NUMBERS mlna ,
299: WMS_TRX_DETAILS_TMP_V mptdtv
325: ,loc.task_id task_id
326: ,NULL locator_inventory_item_id
327: ,NULL empty_flag
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
403: ,sum(base.secondary_quantity)
404: ,base.grade_code
405: ,NULL consist_string
406: ,msn.SERIAL_NUMBER order_by_string
407: from MTL_SERIAL_NUMBERS msn
408: ,MTL_SYSTEM_ITEMS msi
409: ,
410: MTL_LOT_NUMBERS mlna ,
411: WMS_TRX_DETAILS_TMP_V mptdtv