DBA Data[Home] [Help]

APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_UNITS_OF_MEASURE

Line 128: l_uom_code mtl_units_of_measure.uom_code%TYPE;

124: l_lpn_group_id NUMBER;
125:
126: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
127: --Bug #4348794
128: l_uom_code mtl_units_of_measure.uom_code%TYPE;
129:
130:
131: -- For Bug 7440217
132: v_lcm_enabled_org varchar2(1);

Line 254: FROM mtl_units_of_measure muom

250: --Bug #4348794 - Populate RTI with uom code
251: BEGIN
252: SELECT muom.uom_code
253: INTO l_uom_code
254: FROM mtl_units_of_measure muom
255: WHERE muom.unit_of_measure = l_uom;
256: IF (l_debug = 1) THEN
257: print_debug('Unit of measure: ' || l_uom || ', UOM Code: ' || l_uom_code, 1);
258: END IF;

Line 2385: FROM mtl_units_of_measure

2381: IF (p_rcvtxn_uom_code IS NULL) THEN
2382: BEGIN
2383: SELECT uom_code
2384: INTO l_rcvtxn_uom_code
2385: FROM mtl_units_of_measure
2386: WHERE unit_of_measure = p_rcvtxn_uom
2387: AND ROWNUM < 2;
2388: EXCEPTION
2389: WHEN OTHERS THEN

Line 2401: FROM mtl_units_of_measure

2397:
2398: BEGIN
2399: SELECT uom_code
2400: INTO l_prim_uom_code
2401: FROM mtl_units_of_measure
2402: WHERE unit_of_measure = l_rcvtxn_match_table_detail(match_result_count).primary_unit_of_measure
2403: AND ROWNUM < 2;
2404: EXCEPTION
2405: WHEN OTHERS THEN