DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on MTL_UNITS_OF_MEASURE

Line 1007: from mtl_units_of_measure mum

1003: need to get the correct value */
1004: begin
1005: select mum.uom_code
1006: into x_uom_code
1007: from mtl_units_of_measure mum
1008: where mum.unit_of_measure = x_uom; --bug 5841426
1009:
1010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1011: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom_code : '||x_uom_code);

Line 2027: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,

2023: pl.contract_type,
2024: pl.cost_constraint,
2025: pl.clm_idc_type
2026:
2027: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,
2028: financials_system_parameters fsp --
2029: where po_header_id=p_po_header_id and
2030: mum.unit_of_measure (+) = pl.unit_meas_lookup_code and --
2031: --bug #2716412: made pl/msi join an outer join

Line 2871: from mtl_units_of_measure mum

2867: need to get the correct value */
2868: begin
2869: select mum.uom_code
2870: into x_uom_code
2871: from mtl_units_of_measure mum
2872: where mum.unit_of_measure = x_uom; --bug 5841426
2873:
2874: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2875: fnd_log.string(fnd_log.level_statement,g_log_head,'x_uom_code : '||x_uom_code);