APPS.INL_INTEGRATION_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 1024: mtl_units_of_measure muom --Bug#9884458

1020: l_po_UOM_code --Bug#9884458
1021: FROM zx_lines_det_factors zdf,
1022: po_line_locations_all pll,
1023: po_lines_all pl, --Bug#9884458
1024: mtl_units_of_measure muom --Bug#9884458
1025: WHERE pll.line_location_id = p_int_rec(i).po_line_location_id
1026: AND pll.po_line_id = pl.po_line_id --Bug#9884458
1027: AND muom.unit_of_measure = pl.unit_meas_lookup_code --Bug#9884458
1028: AND zdf.application_id = 201

Line 1114: FROM mtl_units_of_measure mum

1110: p_debug_info => 'Get secondary_uom_code from secondary_unit_of_measure');
1111:
1112: SELECT mum.uom_code
1113: INTO l_sec_uom_code
1114: FROM mtl_units_of_measure mum
1115: WHERE mum.unit_of_measure = p_int_rec(i).secondary_unit_of_measure;
1116: END IF;
1117: END IF;
1118:

Line 3260: FROM mtl_units_of_measure

3256:
3257: -- Get the UOM Code
3258: SELECT uom_code
3259: INTO l_lci_table(l_ind_lci).txn_uom_code
3260: FROM mtl_units_of_measure
3261: WHERE unit_of_measure = c_pll_tab(i).unit_meas_lookup_code;
3262:
3263: l_sec_unit_price := NULL;
3264: l_sec_uom_code := NULL;

Line 3284: FROM mtl_units_of_measure mum

3280: p_debug_info => 'Get secondary_uom_code from secondary_unit_of_measure');
3281:
3282: SELECT mum.uom_code
3283: INTO l_sec_uom_code
3284: FROM mtl_units_of_measure mum
3285: WHERE mum.unit_of_measure = c_pll_tab(i).secondary_unit_of_measure;
3286: END IF;
3287:
3288: l_sec_unit_price := (c_pll_tab(i).quantity * c_pll_tab(i).unit_price) / l_sec_qty;

Line 3981: mtl_units_of_measure_vl muv

3977: sl.txn_unit_price,
3978: sl.currency_code
3979: FROM inl_ship_lines_all sl,
3980: inl_ship_headers sh,
3981: mtl_units_of_measure_vl muv
3982: WHERE muv.uom_code = sl.txn_uom_code
3983: AND sl.ship_header_id = sh.ship_header_id
3984: AND sl.ship_line_src_type_code = 'PO'
3985: AND sh.simulation_id = p_simulation_id