[Home] [Help]
113: ,NULL empty_flag
114: ,NULL location_current_units
115: from mtl_serial_numbers msn
116: ,mtl_secondary_inventories sub
117: ,mtl_item_locations loc
118: ,mtl_lot_numbers lot
119: where msn.current_status = 3
120: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
121: decode(g_unit_number, '-9999', 'a', g_unit_number)
208: ,NULL empty_flag
209: ,NULL location_current_units
210: from mtl_serial_numbers msn
211: ,mtl_secondary_inventories sub
212: ,mtl_item_locations loc
213: ,mtl_lot_numbers lot
214: where msn.current_status = 3
215: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
216: decode(g_unit_number, '-9999', 'a', g_unit_number)
322: ,NULL empty_flag
323: ,NULL location_current_units
324: from mtl_serial_numbers msn
325: ,mtl_secondary_inventories sub
326: ,mtl_item_locations loc
327: ,mtl_lot_numbers lot
328: where msn.current_status = 3
329: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
330: decode(g_unit_number, '-9999', 'a', g_unit_number)
470: ,moq.lpn_id lpn_id
471: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
472: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
473: FROM
474: mtl_onhand_quantities_detail moq,mtl_item_locations mils
475: WHERE
476: moq.organization_id = g_organization_id
477: AND moq.inventory_item_id = g_inventory_item_id
478: AND moq.organization_id = mils.organization_id (+)
499: and x.inventory_item_id = lot.inventory_item_id (+)
500: and x.lot_number = lot.lot_number (+)
501: ) x
502: ,mtl_secondary_inventories sub
503: ,mtl_item_locations loc
504: WHERE x.organization_id = loc.organization_id (+)
505: AND x.locator_id = loc.inventory_location_id (+)
506: AND sub.organization_id = x.organization_id
507: AND sub.secondary_inventory_name = x.subinventory_code