APPS.WMS_CARTNZN_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1520: wms_license_plate_numbers

1516: x_content_volume_uom_code,
1517: x_tare_weight,
1518: x_tare_weight_uom_code
1519: FROM
1520: wms_license_plate_numbers
1521: WHERE
1522: lpn_id = p_lpn_id;
1523:
1524: lpn_attr_table(p_lpn_id).inventory_item_id := x_inventory_item_id;

Line 1924: FROM wms_license_plate_numbers

1920: ELSE
1921:
1922: SELECT inventory_item_id
1923: INTO l_ret
1924: FROM wms_license_plate_numbers
1925: WHERE
1926: lpn_id = p_lpn_id;
1927:
1928:

Line 2547: FROM wms_license_plate_numbers

2543: SELECT gross_weight
2544: , gross_weight_uom_code
2545: INTO l_lpn_wt_from_db
2546: , l_wt_uom_from_db
2547: FROM wms_license_plate_numbers
2548: WHERE lpn_id = prev_lpn;
2549:
2550: l_lpn_rec.lpn_id := prev_lpn;
2551: l_lpn_rec.gross_weight := NVL(l_lpn_wt_from_db,0) + fin_wt;

Line 2583: FROM wms_license_plate_numbers

2579:
2580:
2581: SELECT gross_weight_uom_code, gross_weight INTO
2582: gr_wt_uom_code, l_lpn_cur_gr_wt
2583: FROM wms_license_plate_numbers
2584: WHERE lpn_id = lpn_cur.parent_lpn_id;
2585:
2586: prev_lpn := lpn_cur.parent_lpn_id ;
2587:

Line 2652: FROM wms_license_plate_numbers

2648: SELECT gross_weight
2649: , gross_weight_uom_code
2650: INTO l_lpn_wt_from_db
2651: , l_wt_uom_from_db
2652: FROM wms_license_plate_numbers
2653: WHERE lpn_id = prev_lpn;
2654:
2655: l_lpn_rec.lpn_id := prev_lpn;
2656: l_lpn_rec.gross_weight := NVL(l_lpn_wt_from_db,0) + fin_wt;

Line 5036: SELECT lpn_id INTO l_lpn FROM wms_license_plate_numbers WHERE

5032: l_lpn := p_lpn_id;
5033:
5034: elsIF p_lpn_string IS NOT NULL then
5035:
5036: SELECT lpn_id INTO l_lpn FROM wms_license_plate_numbers WHERE
5037: license_plate_number = p_lpn_string;
5038: ELSE
5039:
5040: l_lpn := NULL;

Line 5175: SELECT lpn_id INTO L_lpn FROM wms_license_plate_numbers WHERE

5171: l_lpn := p_lpn_id;
5172:
5173: elsIF p_lpn_string IS NOT NULL THEN
5174:
5175: SELECT lpn_id INTO L_lpn FROM wms_license_plate_numbers WHERE
5176: license_plate_number = p_lpn_string;
5177:
5178: ELSE
5179:

Line 5759: SELECT license_plate_number INTO v_lpn FROM wms_license_plate_numbers WHERE

5755: if (g_trace_on = 1) then log_event(' row_exist '||v_exist); END IF;
5756:
5757: IF v1.cartonization_id IS NOT NULL THEN
5758: IF (g_trace_on = 1) then log_event(' Cartonization id '||v1.cartonization_id); END IF;
5759: SELECT license_plate_number INTO v_lpn FROM wms_license_plate_numbers WHERE
5760: lpn_id = v1.cartonization_id;
5761: ELSE
5762: v_lpn := NULL;
5763: --2513907 fix