APPS.AP_IMPORT_VALIDATION_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 20057: FROM mtl_units_of_measure

20053: END IF;
20054: BEGIN
20055: SELECT 'Valid UOM'
20056: INTO l_uom_is_valid
20057: FROM mtl_units_of_measure
20058: WHERE unit_of_measure = p_invoice_lines_rec.unit_of_meas_lookup_code
20059: AND AP_IMPORT_INVOICES_PKG.g_inv_sysdate
20060: < nvl(disable_date, AP_IMPORT_INVOICES_PKG.g_inv_sysdate + 1) ;
20061: EXCEPTION

Line 21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;

21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
21817: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
21818:
21819: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21821:
21822: l_error_code VARCHAR2(500);
21823: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
21824: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;

Line 23447: l_uom_code mtl_units_of_measure.uom_code%TYPE;

23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
23446: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
23447: l_uom_code mtl_units_of_measure.uom_code%TYPE;
23448: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
23449: l_error_code varchar2(2000);
23450: current_calling_sequence VARCHAR2(2000);
23451: l_success boolean;