APPS.JAI_PO_PROC_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 628: FROM Mtl_Units_Of_Measure

624: WHERE line_location_id = c_line_loc_id;
625:
626: CURSOR Fetch_UOMCode_Cur IS
627: SELECT Uom_Code
628: FROM Mtl_Units_Of_Measure
629: WHERE Unit_Of_Measure = v_uom_measure;
630:
631: CURSOR Fetch_Org_Id_Cur IS
632: SELECT Inventory_Organization_Id

Line 1909: FROM Mtl_Units_Of_Measure

1905: WHERE Po_Line_Id = pn_line_id;
1906:
1907: CURSOR Fetch_UOMCode_Cur( v_uom IN VARCHAR2 ) IS
1908: SELECT Uom_Code
1909: FROM Mtl_Units_Of_Measure
1910: WHERE Unit_Of_Measure = v_uom;
1911:
1912: CURSOR c_get_po_line_loc_details IS
1913: SELECT DISTINCT item_id

Line 2271: FROM mtl_units_of_measure

2267: WHERE line_location_id = p_line_location_id;
2268:
2269: CURSOR fetch_uomcode_cur IS
2270: SELECT uom_code
2271: FROM mtl_units_of_measure
2272: WHERE unit_of_measure = v_uom_measure;
2273:
2274: CURSOR Fetch_Count_Cur (cn_po_hdr_id NUMBER)IS
2275: SELECT COUNT(Line_Location_Id)

Line 4127: FROM Mtl_Units_Of_Measure

4123:
4124:
4125:
4126: CURSOR Fetch_Uom_Code_Cur IS SELECT Uom_Code
4127: FROM Mtl_Units_Of_Measure
4128: WHERE Unit_Of_Measure = v_uom;
4129:
4130: CURSOR Fetch_Mod_Flag_Cur IS Select Tax_modified_Flag
4131: From JAI_PO_REQ_LINES

Line 4523: FROM Mtl_Units_Of_Measure

4519:
4520:
4521: CURSOR Fetch_Uom_Code_Cur(cp_unit_of_meas VARCHAR2) IS
4522: SELECT Uom_Code
4523: FROM Mtl_Units_Of_Measure
4524: WHERE Unit_Of_Measure = cp_unit_of_meas;
4525:
4526:
4527: CURSOR c_reqn_line_id(p_reqn_line_id Number) is

Line 4874: FROM Mtl_Units_Of_Measure

4870: WHERE Po_Line_Id = v_po_line_id;
4871:
4872: CURSOR Fetch_UomCode_Cur(p_uom IN VARCHAR2) IS
4873: SELECT Uom_Code
4874: FROM Mtl_Units_Of_Measure
4875: WHERE Unit_Of_Measure = p_uom;
4876:
4877: -- Pick up vendor id for the corresponding Po_Header_Id
4878: CURSOR Fetch_Po_Vendor_Id_Cur( hdr_id IN NUMBER ) IS

Line 5678: v_junk_uom MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE;

5674: WHERE line_location_id = p_src_ship_id
5675: AND po_line_id = v_po_line_id;
5676:
5677:
5678: v_junk_uom MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE;
5679: CURSOR Fetch_Qty_Cur( llid IN NUMBER ) IS
5680: SELECT Quantity, Price_Override, Unit_Meas_Lookup_Code
5681: FROM Po_Line_Locations_All
5682: WHERE Line_Location_Id = llid;

Line 5745: FROM Mtl_Units_Of_Measure

5741: WHERE Po_Line_Id = p_line_id;
5742:
5743: CURSOR Fetch_UOMCode_Cur( uom IN VARCHAR2 ) IS
5744: SELECT Uom_Code
5745: FROM Mtl_Units_Of_Measure
5746: WHERE Unit_Of_Measure = uom;
5747:
5748: CURSOR Fetch_Tot_Sum_Cur( llid IN NUMBER ) IS
5749: SELECT SUM( NVL( Tax_Amount, 0 ) )

Line 6599: FROM Mtl_Units_Of_Measure

6595: WHERE po_header_id = cn_po_hdr_id;
6596:
6597: CURSOR Fetch_UOMCode_Cur( v_uom IN VARCHAR2 ) IS
6598: SELECT Uom_Code
6599: FROM Mtl_Units_Of_Measure
6600: WHERE Unit_Of_Measure = v_uom;
6601:
6602: CURSOR Fetch_Lines_Cur IS
6603: SELECT Line_location_id, Price_Override, Quantity

Line 6877: FROM mtl_units_of_measure

6873: WHERE po_header_id = cn_po_hdr_id;
6874:
6875: CURSOR fetch_uomcode_cur IS
6876: SELECT uom_code
6877: FROM mtl_units_of_measure
6878: WHERE unit_of_measure = v_uom_measure;
6879:
6880: CURSOR c_po_line(cn_po_line_id NUMBER) IS
6881: SELECT *

Line 7186: FROM Mtl_Units_Of_Measure

7182: WHERE PO_LINE_ID = cn_po_line_id;
7183:
7184: CURSOR Fetch_UOMCode_Cur( c_uom IN VARCHAR2 ) IS
7185: SELECT Uom_Code
7186: FROM Mtl_Units_Of_Measure
7187: WHERE Unit_Of_Measure = c_uom;
7188:
7189: CURSOR tax_override_flag_cur(c_supplier_id number, c_supp_site_id number) IS
7190: SELECT override_flag

Line 7870: FROM mtl_units_of_measure

7866: WHERE po_header_id = cn_po_hdr_id;
7867:
7868: CURSOR fetch_uomcode_cur IS
7869: SELECT uom_code
7870: FROM mtl_units_of_measure
7871: WHERE unit_of_measure = v_uom_measure;
7872:
7873: CURSOR c_po_line(cn_po_line_id NUMBER) IS
7874: SELECT *

Line 8302: FROM Mtl_Units_Of_Measure

8298: WHERE Po_Line_Id = v_po_line_id;
8299:
8300: CURSOR Fetch_UomCode_Cur(p_uom IN VARCHAR2) IS
8301: SELECT Uom_Code
8302: FROM Mtl_Units_Of_Measure
8303: WHERE Unit_Of_Measure = p_uom;
8304:
8305: -- Pick up vendor id for the corresponding Po_Header_Id
8306: CURSOR Fetch_Po_Vendor_Id_Cur( hdr_id IN NUMBER ) IS