APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 169: FROM Mtl_Units_Of_Measure

165:
166: --CURSOR Fetch_Uom_Code_Cur IS pramasub FP start
167: CURSOR Fetch_Uom_Code_Cur(cp_unit_of_meas VARCHAR2) IS /*4281841*/
168: SELECT Uom_Code
169: FROM Mtl_Units_Of_Measure
170: WHERE Unit_Of_Measure = cp_unit_of_meas;
171: --WHERE Unit_Of_Measure = v_uom_code; pramasub start
172:
173: -- additions by sriram - starts here Bug # 2977200

Line 583: FROM Mtl_Units_of_Measure

579: CLOSE site_cur;
580:
581: SELECT Uom_Code
582: INTO v_uom_code
583: FROM Mtl_Units_of_Measure
584: WHERE Unit_Of_Measure = pr_new.Unit_Meas_Lookup_Code;
585:
586: v_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value( v_vendor_id, v_site_id,
587: v_inventory_item_id, v_uom_code );

Line 946: FROM Mtl_Units_Of_Measure

942: WHERE Po_Line_Id = v_po_line_id;
943:
944: CURSOR Fetch_UomCode_Cur(p_uom IN VARCHAR2) IS
945: SELECT Uom_Code
946: FROM Mtl_Units_Of_Measure
947: WHERE Unit_Of_Measure = p_uom;
948:
949: -- Pick up vendor id for the corresponding Po_Header_Id
950: CURSOR Fetch_Po_Vendor_Id_Cur( hdr_id IN NUMBER ) IS

Line 1828: FROM Mtl_Units_Of_Measure

1824: * and implemented the same using caching logic.
1825: */
1826:
1827: CURSOR Fetch_Uom_Code_Cur IS SELECT Uom_Code
1828: FROM Mtl_Units_Of_Measure
1829: WHERE Unit_Of_Measure = v_uom;
1830:
1831: CURSOR Fetch_Mod_Flag_Cur IS Select Tax_modified_Flag
1832: From JAI_PO_REQ_LINES

Line 2565: FROM Mtl_Units_Of_Measure

2561: FROM Po_Requisition_Headers_V
2562: WHERE Requisition_Header_Id = v_header_id;
2563:
2564: CURSOR Fetch_Uom_Code_Cur IS SELECT Uom_Code
2565: FROM Mtl_Units_Of_Measure
2566: WHERE Unit_Of_Measure = v_uom;
2567:
2568: CURSOR Fetch_Mod_Flag_Cur IS SELECT Tax_modIFied_Flag
2569: From JAI_PO_REQ_LINES