APPS.JAI_PO_TAX_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 233: FROM po_lines_all plines, mtl_units_of_measure units

229: -- 6/05/02 cbabu. added to fetch UOM_code in case if it is null. if this is null then we will get problems during quantity rate tax.
230: -- 6/05/02 cbabu bug2357371
231: CURSOR Fetch_line_uom_code IS
232: SELECT Uom_Code
233: FROM po_lines_all plines, mtl_units_of_measure units
234: WHERE plines.Po_Line_Id = p_line_id
235: AND units.Unit_Of_Measure = plines.unit_meas_lookup_code;
236:
237: CURSOR fetch_rcv_line_currency is

Line 355: FROM mtl_units_of_measure A, mtl_units_of_measure B

351: -- end of modifications by subbu on 7-nov-01 for considering adhoc taxes in PR to PO / BPO to Brelease
352:
353: CURSOR uom_class_cur(p_line_uom_code IN VARCHAR2, p_tax_line_uom_code IN VARCHAR2) IS
354: SELECT A.uom_class
355: FROM mtl_units_of_measure A, mtl_units_of_measure B
356: WHERE A.uom_code = p_line_uom_code
357: AND B.uom_code = p_tax_line_uom_code
358: AND A.uom_class = B.uom_class;
359:

Line 2481: FROM Mtl_Units_Of_Measure

2477: AND Line_Location_Id = linelocid;
2478: -- Get the Uom Code
2479:
2480: CURSOR Fetch_UOMCode_Cur IS SELECT Uom_Code
2481: FROM Mtl_Units_Of_Measure
2482: WHERE Unit_Of_Measure = v_uom;
2483:
2484: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.copy_reqn_taxes';
2485: BEGIN

Line 2951: FROM mtl_units_of_measure a, mtl_units_of_measure b

2947: /* end rallamse Bug#4250072 VAT implementation */
2948:
2949: CURSOR uom_class_cur(p_line_uom_code IN VARCHAR2, p_tax_line_uom_code IN VARCHAR2) IS
2950: SELECT a.uom_class
2951: FROM mtl_units_of_measure a, mtl_units_of_measure b
2952: WHERE a.uom_code = p_line_uom_code
2953: AND b.uom_code = p_tax_line_uom_code
2954: AND a.uom_class = b.uom_class;
2955:

Line 2964: FROM po_lines_all plines, mtl_units_of_measure units

2960: AND tax_type <> jai_constants.tax_type_tds; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2961:
2962: CURSOR fetch_line_uom_code IS
2963: SELECT uom_code
2964: FROM po_lines_all plines, mtl_units_of_measure units
2965: WHERE plines.po_line_id = p_line_id
2966: AND units.unit_of_measure = plines.unit_meas_lookup_code;
2967:
2968: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.calc_tax';

Line 5842: v_junk_uom MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE; -- Added by Vijay Shankar for Bug# 3205861

5838: FROM JAI_PO_REQUEST_T
5839: WHERE line_focus_id = p_seq_val -- Modified By Sjha
5840: ORDER BY Tax_Line_No;
5841:
5842: v_junk_uom MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE; -- Added by Vijay Shankar for Bug# 3205861
5843: CURSOR Fetch_Qty_Cur( llid IN NUMBER ) IS
5844: SELECT Quantity, Price_Override, Unit_Meas_Lookup_Code
5845: FROM Po_Line_Locations_All
5846: WHERE Line_Location_Id = llid;

Line 5910: FROM Mtl_Units_Of_Measure

5906: WHERE Po_Line_Id = p_line_id;
5907:
5908: CURSOR Fetch_UOMCode_Cur( uom IN VARCHAR2 ) IS
5909: SELECT Uom_Code
5910: FROM Mtl_Units_Of_Measure
5911: WHERE Unit_Of_Measure = uom;
5912:
5913: CURSOR Fetch_Tot_Sum_Cur( llid IN NUMBER ) IS
5914: SELECT SUM( NVL( Tax_Amount, 0 ) )

Line 6683: FROM Mtl_Units_Of_Measure

6679: v_tax_category_id_dflt JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
6680:
6681: CURSOR Fetch_UOMCode_Cur IS
6682: SELECT Uom_Code
6683: FROM Mtl_Units_Of_Measure
6684: WHERE Unit_Of_Measure = v_uom_measure;
6685:
6686: CURSOR Fetch_Focus_Id_Cur IS
6687: SELECT Line_Focus_Id

Line 7143: FROM Mtl_Units_Of_Measure

7139: AND Organization_id = v_org_id;
7140:
7141: CURSOR Fetch_UOMCode_Cur IS
7142: SELECT Uom_Code
7143: FROM Mtl_Units_Of_Measure
7144: WHERE Unit_Of_Measure = v_uom_measure;
7145:
7146: CURSOR Fetch_Focus_Id IS
7147: SELECT Line_Focus_Id