869: mtl_item_locations_kfv milk,
870: wms_lpn_contents wlc,
871: mtl_serial_numbers msn,
872: mtl_serial_numbers_temp msnt,
873: mtl_transaction_lots_temp mtlt,
874: mtl_material_transactions_temp mmtt
875: WHERE wlpn.organization_id = milk.organization_id (+)
876: AND wlpn.locator_id = milk.inventory_location_id(+)
877: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
969: mtl_item_locations_kfv milk,
970: wms_lpn_contents wlc,
971: mtl_serial_numbers msn,
972: mtl_serial_numbers_temp msnt,
973: mtl_transaction_lots_temp mtlt,
974: mtl_material_transactions_temp mmtt
975: WHERE wlpn.organization_id = milk.organization_id (+)
976: AND wlpn.locator_id = milk.inventory_location_id(+)
977: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
1067: mtl_item_locations_kfv milk,
1068: wms_lpn_contents wlc,
1069: mtl_serial_numbers msn,
1070: mtl_serial_numbers_temp msnt,
1071: mtl_transaction_lots_temp mtlt,
1072: mtl_material_transactions_temp mmtt
1073: WHERE wlpn.organization_id = milk.organization_id (+)
1074: AND wlpn.locator_id = milk.inventory_location_id(+)
1075: AND wlc.parent_lpn_id (+) = wlpn.lpn_id