APPS.WMS_CARTNZN_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1427: wms_license_plate_numbers

1423: x_content_volume_uom_code,
1424: x_tare_weight,
1425: x_tare_weight_uom_code
1426: FROM
1427: wms_license_plate_numbers
1428: WHERE
1429: lpn_id = p_lpn_id;
1430:
1431: lpn_attr_table(p_lpn_id).inventory_item_id := x_inventory_item_id;

Line 1831: FROM wms_license_plate_numbers

1827: ELSE
1828:
1829: SELECT inventory_item_id
1830: INTO l_ret
1831: FROM wms_license_plate_numbers
1832: WHERE
1833: lpn_id = p_lpn_id;
1834:
1835:

Line 2522: FROM wms_license_plate_numbers

2518: SELECT gross_weight
2519: , gross_weight_uom_code
2520: INTO l_lpn_wt_from_db
2521: , l_wt_uom_from_db
2522: FROM wms_license_plate_numbers
2523: WHERE lpn_id = prev_lpn;
2524:
2525: l_lpn_rec.lpn_id := prev_lpn;
2526: l_lpn_rec.gross_weight := NVL(l_lpn_wt_from_db,0) + fin_wt;

Line 2558: FROM wms_license_plate_numbers

2554:
2555:
2556: SELECT gross_weight_uom_code, gross_weight INTO
2557: gr_wt_uom_code, l_lpn_cur_gr_wt
2558: FROM wms_license_plate_numbers
2559: WHERE lpn_id = lpn_cur.parent_lpn_id;
2560:
2561: prev_lpn := lpn_cur.parent_lpn_id ;
2562:

Line 2627: FROM wms_license_plate_numbers

2623: SELECT gross_weight
2624: , gross_weight_uom_code
2625: INTO l_lpn_wt_from_db
2626: , l_wt_uom_from_db
2627: FROM wms_license_plate_numbers
2628: WHERE lpn_id = prev_lpn;
2629:
2630: l_lpn_rec.lpn_id := prev_lpn;
2631: l_lpn_rec.gross_weight := NVL(l_lpn_wt_from_db,0) + fin_wt;

Line 5029: SELECT lpn_id INTO l_lpn FROM wms_license_plate_numbers WHERE

5025: l_lpn := p_lpn_id;
5026:
5027: elsIF p_lpn_string IS NOT NULL then
5028:
5029: SELECT lpn_id INTO l_lpn FROM wms_license_plate_numbers WHERE
5030: license_plate_number = p_lpn_string;
5031: ELSE
5032:
5033: l_lpn := NULL;

Line 5201: SELECT lpn_id INTO L_lpn FROM wms_license_plate_numbers WHERE

5197: l_lpn := p_lpn_id;
5198:
5199: elsIF p_lpn_string IS NOT NULL THEN
5200:
5201: SELECT lpn_id INTO L_lpn FROM wms_license_plate_numbers WHERE
5202: license_plate_number = p_lpn_string;
5203:
5204: ELSE
5205:

Line 5798: SELECT license_plate_number INTO v_lpn FROM wms_license_plate_numbers WHERE

5794: if (g_trace_on = 1) then log_event(' row_exist '||v_exist); END IF;
5795:
5796: IF v1.cartonization_id IS NOT NULL THEN
5797: IF (g_trace_on = 1) then log_event(' Cartonization id '||v1.cartonization_id); END IF;
5798: SELECT license_plate_number INTO v_lpn FROM wms_license_plate_numbers WHERE
5799: lpn_id = v1.cartonization_id;
5800: ELSE
5801: v_lpn := NULL;
5802: --2513907 fix