APPS.JAI_PO_TAX_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 277: FROM po_lines_all plines, mtl_units_of_measure units

273: -- 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.
274: -- 6/05/02 cbabu bug2357371
275: CURSOR Fetch_line_uom_code IS
276: SELECT Uom_Code
277: FROM po_lines_all plines, mtl_units_of_measure units
278: WHERE plines.Po_Line_Id = p_line_id
279: AND units.Unit_Of_Measure = plines.unit_meas_lookup_code;
280:
281: CURSOR fetch_rcv_line_currency is

Line 405: FROM mtl_units_of_measure A, mtl_units_of_measure B

401: -- end of modifications by subbu on 7-nov-01 for considering adhoc taxes in PR to PO / BPO to Brelease
402:
403: CURSOR uom_class_cur(p_line_uom_code IN VARCHAR2, p_tax_line_uom_code IN VARCHAR2) IS
404: SELECT A.uom_class
405: FROM mtl_units_of_measure A, mtl_units_of_measure B
406: WHERE A.uom_code = p_line_uom_code
407: AND B.uom_code = p_tax_line_uom_code
408: AND A.uom_class = B.uom_class;
409:

Line 3205: FROM Mtl_Units_Of_Measure

3201: AND Line_Location_Id = linelocid;
3202: -- Get the Uom Code
3203:
3204: CURSOR Fetch_UOMCode_Cur IS SELECT Uom_Code
3205: FROM Mtl_Units_Of_Measure
3206: WHERE Unit_Of_Measure = v_uom;
3207:
3208: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.copy_reqn_taxes';
3209: BEGIN

Line 3723: FROM mtl_units_of_measure a, mtl_units_of_measure b

3719: /* end rallamse Bug#4250072 VAT implementation */
3720:
3721: CURSOR uom_class_cur(p_line_uom_code IN VARCHAR2, p_tax_line_uom_code IN VARCHAR2) IS
3722: SELECT a.uom_class
3723: FROM mtl_units_of_measure a, mtl_units_of_measure b
3724: WHERE a.uom_code = p_line_uom_code
3725: AND b.uom_code = p_tax_line_uom_code
3726: AND a.uom_class = b.uom_class;
3727:

Line 3736: FROM po_lines_all plines, mtl_units_of_measure units

3732: AND tax_type <> jai_constants.tax_type_tds; --'TDS'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3733:
3734: CURSOR fetch_line_uom_code IS
3735: SELECT uom_code
3736: FROM po_lines_all plines, mtl_units_of_measure units
3737: WHERE plines.po_line_id = p_line_id
3738: AND units.unit_of_measure = plines.unit_meas_lookup_code;
3739:
3740: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_tax_pkg.calc_tax';

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

7254: FROM JAI_PO_REQUEST_T
7255: WHERE line_focus_id = p_seq_val -- Modified By Sjha
7256: ORDER BY Tax_Line_No;
7257:
7258: v_junk_uom MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE; -- Added by Vijay Shankar for Bug# 3205861
7259: CURSOR Fetch_Qty_Cur( llid IN NUMBER ) IS
7260: SELECT Quantity, Price_Override, Unit_Meas_Lookup_Code
7261: FROM Po_Line_Locations_All
7262: WHERE Line_Location_Id = llid;

Line 7326: FROM Mtl_Units_Of_Measure

7322: WHERE Po_Line_Id = p_line_id;
7323:
7324: CURSOR Fetch_UOMCode_Cur( uom IN VARCHAR2 ) IS
7325: SELECT Uom_Code
7326: FROM Mtl_Units_Of_Measure
7327: WHERE Unit_Of_Measure = uom;
7328:
7329: CURSOR Fetch_Tot_Sum_Cur( llid IN NUMBER ) IS
7330: SELECT SUM( NVL( Tax_Amount, 0 ) )

Line 8166: FROM Mtl_Units_Of_Measure

8162: v_tax_category_id_dflt JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE; -- cbabu for EnhancementBug# 2427465
8163:
8164: CURSOR Fetch_UOMCode_Cur IS
8165: SELECT Uom_Code
8166: FROM Mtl_Units_Of_Measure
8167: WHERE Unit_Of_Measure = v_uom_measure;
8168:
8169: CURSOR Fetch_Focus_Id_Cur IS
8170: SELECT Line_Focus_Id

Line 8663: FROM Mtl_Units_Of_Measure

8659: AND Organization_id = v_org_id;
8660:
8661: CURSOR Fetch_UOMCode_Cur IS
8662: SELECT Uom_Code
8663: FROM Mtl_Units_Of_Measure
8664: WHERE Unit_Of_Measure = v_uom_measure;
8665:
8666: CURSOR Fetch_Focus_Id IS
8667: SELECT Line_Focus_Id