APPS.ICX_POR_EXT_ITEM dependencies on MTL_UNITS_OF_MEASURE_TL

Line 5552: xOneValidUomCode MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;

5548: xWhereStr VARCHAR2(4000) := NULL;
5549: xString VARCHAR2(4000) := NULL;
5550: -- Bug#3352834
5551: xTmpReqId PLS_INTEGER := NULL;
5552: xOneValidUomCode MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
5553:
5554: BEGIN
5555: xErrLoc := 100;
5556:

Line 5578: FROM mtl_units_of_measure_tl

5574: * for bypassing the Outer join issues for the FPLT Items. */
5575:
5576: SELECT unit_of_measure
5577: INTO xOneValidUomCode
5578: FROM mtl_units_of_measure_tl
5579: WHERE rownum = 1;
5580:
5581: xErrLoc := 150;
5582:

Line 5757: 'mtl_units_of_measure_tl uomtl, '||

5753: --FPJ FPSL Extractor Changes
5754: 'po_line_types_b pltb, ';
5755: END IF;
5756: xViewStr2 := xViewStr2 ||
5757: 'mtl_units_of_measure_tl uomtl, '||
5758: 'gl_currencies gc '||
5759: -- Bug#3213218/3163334 : pcreddy - Check for the load flag to be 'Y'.
5760: 'WHERE ( (l.load_template_lines = ''Y'' AND ' ||
5761: ' l.template_lines_last_run_date IS NULL) OR ' ||

Line 6016: 'mtl_units_of_measure_tl uomtl, '||

6012: --FPJ FPSL Extractor Changes
6013: 'po_line_types_b pltb, ';
6014: END IF;
6015: xViewStr2 := xViewStr2 ||
6016: 'mtl_units_of_measure_tl uomtl, '||
6017: 'gl_currencies gc, '||
6018: --Bug : 4474307
6019: 'mtl_categories_kfv mck ' ||
6020: 'WHERE (l.contracts_last_run_date IS NULL OR '||

Line 6296: 'mtl_units_of_measure_tl muom, '||

6292: 'gl_sets_of_books gsb, '||
6293: 'financials_system_params_all fsp, ';
6294: END IF;
6295: xViewStr2 := xViewStr2 ||
6296: 'mtl_units_of_measure_tl muom, '||
6297: '(SELECT '||PURCHASING_ITEM_TYPE||' document_type, '||
6298: '''PURCHASING_ITEM'' price_type, '||
6299: '''SUPPLIER'' price_search_type '||
6300: 'FROM dual '||