[Home] [Help]
391: BEGIN
392:
393: SELECT lpn_id
394: INTO l_lpn_id
395: FROM wms_license_plate_numbers
396: WHERE license_plate_number = p_lpn
397: AND organization_id = p_org_id;
398:
399: RETURN l_lpn_id;
1087: mr.secondary_reservation_quantity || ', ' ||
1088: mr.secondary_uom_code || ', ' ||
1089: Nvl(mr.secondary_detailed_quantity,0) as p_text
1090: INTO l_rt
1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
1092: WHERE reservation_id = l_new_reservation_id
1093: AND msi.organization_id = mr.organization_id
1094: AND msi.inventory_item_id = mr.inventory_item_id
1095: AND mp.organization_id = mr.organization_id
2219: mr.secondary_reservation_quantity || ', ' ||
2220: mr.secondary_uom_code || ', ' ||
2221: Nvl(mr.secondary_detailed_quantity,0) as p_text,
2222: mr.reservation_id as reservation_id
2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
2224: WHERE
2225: Nvl(mr.supply_source_type_id, 13) = 13
2226: AND g_demand_tbl(p_di).demand_source_type_id = mr.demand_source_type_id
2227: AND nvl(g_demand_tbl(p_di).demand_source_header_id,-9999) = nvl(mr.demand_source_header_id, -9999)
2504: , x_msg_data => l_msg_data
2505: , p_organization_id => p_org_id
2506: , p_outermost_lpn_id => l_lpn_id);
2507:
2508: UPDATE wms_license_plate_numbers
2509: SET parent_lpn_id = lpn_id
2510: WHERE parent_lpn_id = l_lpn_id;
2511:
2512: UPDATE wms_license_plate_numbers
2508: UPDATE wms_license_plate_numbers
2509: SET parent_lpn_id = lpn_id
2510: WHERE parent_lpn_id = l_lpn_id;
2511:
2512: UPDATE wms_license_plate_numbers
2513: SET outermost_lpn_id = parent_lpn_id
2514: WHERE outermost_lpn_id = l_lpn_id;
2515:
2516: END LOOP;