[Home] [Help]
2737: l_update_instance_rec.instance_usage_code := 'OUT_OF_SERVICE';
2738: Begin
2739: SELECT nvl(location_id,NULL)
2740: INTO l_update_instance_rec.location_id
2741: FROM hr_all_organization_units
2742: WHERE organization_id = l_src_instance_header_tbl(i).vld_organization_id;
2743: Exception
2744: WHEN no_data_found THEN
2745: null;
3428: mtl_system_items_b msib,
3429: mtl_serial_numbers msn,
3430: mtl_unit_transactions mut,
3431: mtl_secondary_inventories msi,
3432: hr_all_organization_units haou,
3433: rcv_transactions rt,
3434: mtl_material_transactions mmt
3435: WHERE
3436: mmt.transaction_id = p_transaction_id AND
3494: mtl_serial_numbers msn,
3495: mtl_unit_transactions mut,
3496: mtl_transaction_lot_numbers mtln,
3497: mtl_secondary_inventories msi,
3498: hr_all_organization_units haou,
3499: rcv_transactions rt,
3500: mtl_material_transactions mmt
3501: WHERE
3502: mmt.transaction_id = p_transaction_id AND
3647: mtl_system_items_b msib,
3648: mtl_serial_numbers msn,
3649: mtl_unit_transactions mut,
3650: mtl_secondary_inventories msi,
3651: hr_all_organization_units haou,
3652: rcv_transactions rt,
3653: mtl_material_transactions mmt
3654: WHERE
3655: mmt.transaction_id = p_transaction_id AND
3715: mtl_serial_numbers msn,
3716: mtl_unit_transactions mut,
3717: mtl_transaction_lot_numbers mtln,
3718: mtl_secondary_inventories msi,
3719: hr_all_organization_units haou,
3720: rcv_transactions rt,
3721: mtl_material_transactions mmt
3722: WHERE
3723: mmt.transaction_id = p_transaction_id AND