[Home] [Help]
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
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)
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
219: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
220: decode(g_unit_number, '-9999', 'a', g_unit_number)
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
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)
476: ,moq.lpn_id lpn_id
477: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
478: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
479: FROM
480: mtl_onhand_quantities_detail moq,mtl_item_locations mils
481: WHERE
482: moq.organization_id = g_organization_id
483: AND moq.inventory_item_id = g_inventory_item_id
484: AND moq.organization_id = mils.organization_id (+)
505: and x.inventory_item_id = lot.inventory_item_id (+)
506: and x.lot_number = lot.lot_number (+)
507: ) x
508: ,mtl_secondary_inventories sub
509: ,mtl_item_locations loc
510: WHERE x.organization_id = loc.organization_id (+)
511: AND x.locator_id = loc.inventory_location_id (+)
512: AND sub.organization_id = x.organization_id
513: AND sub.secondary_inventory_name = x.subinventory_code