DBA Data[Home] [Help]

APPS.WMS_ENGINE_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1909: FROM wms_license_plate_numbers wlpn

1905: l_progress := 100;
1906:
1907: SELECT lpn_context
1908: INTO l_lpn_context
1909: FROM wms_license_plate_numbers wlpn
1910: WHERE lpn_id = (SELECT lpn_id
1911: FROM mtl_txn_request_lines mtrl
1912: WHERE mtrl.line_id = p_transaction_temp_id)
1913: AND EXISTS(SELECT 1 FROM wms_lpn_contents wlc, mtl_txn_request_lines mtrl -- for bug 14035958

Line 1952: FROM wms_license_plate_numbers

1948:
1949: BEGIN
1950: SELECT lpn_context
1951: INTO l_lpn_context
1952: FROM wms_license_plate_numbers
1953: WHERE lpn_id = l_request_line_rec.lpn_id ; /* (SELECT lpn_id
1954: FROM mtl_txn_request_lines mtrl
1955: WHERE mtrl.line_id = p_transaction_temp_id);*/
1956: