DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on PO_LINES_ALL

Line 226: FROM Po_Lines_All

222: --Add by Eric Ma for Retro Active Pricing Update on Jan 11, 2008 ,End
223:
224: CURSOR Fetch_Item_Cur IS
225: SELECT Item_Id
226: FROM Po_Lines_All
227: WHERE Po_Line_Id = p_line_id;
228:
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

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 2460: FROM Po_Lines_All

2456: FROM Po_Line_Locations_all
2457: WHERE Po_Header_Id = v_po_hdr_id;
2458:
2459: CURSOR Fetch_Item_Cur( Lineid IN NUMBER ) IS SELECT Item_Id
2460: FROM Po_Lines_All
2461: WHERE Po_Line_Id = Lineid;
2462:
2463: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS SELECT Line_Location_Id
2464: FROM po_line_locations_all

Line 2470: FROM Po_Lines_All

2466:
2467: ------------------------------ ------------------------------ ------------------------------ ------------------------------
2468:
2469: CURSOR Fetch_Dtls_Cur( lineid IN NUMBER ) IS SELECT Quantity, Unit_Price, Unit_Meas_Lookup_Code
2470: FROM Po_Lines_All
2471: WHERE Po_Line_Id = lineid;
2472:
2473: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS SELECT Quantity, Price_Override,
2474: Unit_Meas_Lookup_Code

Line 2845: FROM po_lines_all

2841: */
2842:
2843: CURSOR fetch_item_cur IS
2844: SELECT item_id
2845: FROM po_lines_all
2846: WHERE po_line_id = p_line_id;
2847: /* Added by LGOPALSA. Bug 4210102.
2848: Added CVD and Excise education cess
2849: */

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 5165: po_lines_all pla, po_headers_all pha

5161:
5162: CURSOR Fetch_Line_Loc_Id_Cur IS
5163: SELECT jpll.Line_Location_Id
5164: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
5165: po_lines_all pla, po_headers_all pha
5166: WHERE pha.po_header_id = pla.po_header_id
5167: AND jpll.line_location_id = plla.line_location_id
5168: AND pha.po_header_id = plla.po_header_id
5169: AND pla.po_line_id = plla.po_line_id

Line 5175: -- Cursor definition for picking po_line_id from po_lines_all

5171: AND pla.line_num = p_line_num
5172: AND pla.item_id = p_item_id
5173: AND plla.shipment_num = p_ship_num;
5174:
5175: -- Cursor definition for picking po_line_id from po_lines_all
5176: CURSOR fetch_line_id_cur IS
5177: SELECT pla.Po_Line_Id
5178: FROM po_lines_all pla, po_headers_all pha
5179: WHERE pha.Po_Header_Id = p_from_hdr_id

Line 5178: FROM po_lines_all pla, po_headers_all pha

5174:
5175: -- Cursor definition for picking po_line_id from po_lines_all
5176: CURSOR fetch_line_id_cur IS
5177: SELECT pla.Po_Line_Id
5178: FROM po_lines_all pla, po_headers_all pha
5179: WHERE pha.Po_Header_Id = p_from_hdr_id
5180: AND pla.line_num = p_line_num -- Vijay Shankar for Bug# 3466223
5181: AND pha.po_header_id =pla.po_header_id;
5182:

Line 5555: FROM po_lines_all

5551:
5552: CURSOR cur_item
5553: IS
5554: SELECT ITEM_ID
5555: FROM po_lines_all
5556: WHERE po_line_id = p_po_line_id;
5557:
5558: lv_item_id po_lines_all.item_id%type;
5559:

Line 5558: lv_item_id po_lines_all.item_id%type;

5554: SELECT ITEM_ID
5555: FROM po_lines_all
5556: WHERE po_line_id = p_po_line_id;
5557:
5558: lv_item_id po_lines_all.item_id%type;
5559:
5560: vendor_rec cur_vendor%ROWTYPE;
5561: v_check_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --Nagaraj.s for Bug2953445.
5562: v_tax_amount NUMBER;--Nagaraj.s for Bug2953445.

Line 5905: FROM Po_Lines_All

5901: AND line_location_id=p_line_loc_id;
5902:
5903: CURSOR Fetch_Lineid_Cur IS
5904: SELECT Po_Line_Id, Unit_Price, Unit_Meas_Lookup_Code, Item_Id
5905: FROM Po_Lines_All
5906: WHERE Po_Line_Id = p_line_id;
5907:
5908: CURSOR Fetch_UOMCode_Cur( uom IN VARCHAR2 ) IS
5909: SELECT Uom_Code

Line 5926: FROM Po_Lines_All

5922: WHERE Po_Header_Id = v_po_hdr_id;
5923:
5924: CURSOR Get_Item_Id_Cur IS
5925: SELECT Item_Id
5926: FROM Po_Lines_All
5927: WHERE Po_Line_Id = v_po_line_id;
5928:
5929: -- added by Vijay Shankar for Bug# 3487904
5930: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS

Line 6568: when making a call to jai_po_tax_pkg.calculate_tax procedure, v_uom is going as NULL and so the procedure is making a call to po_lines_all

6564: CHANGE HISTORY for FILENAME - ja_in_po_default_taxes_pkg.sql
6565: S.No Date Author and Details
6566: -------------------------------------------------
6567: 1 5/12/2002 Vijay Shankar for Bug# 2695844, FileVersion: 615.1
6568: when making a call to jai_po_tax_pkg.calculate_tax procedure, v_uom is going as NULL and so the procedure is making a call to po_lines_all
6569: table to fetch the uom and which is giving the mutating error.
6570: Created a new variable v_uom_code and passing the same to jai_po_tax_pkg.calculate_tax that will not make a query on po_lines_all
6571:
6572: 2 6/12/2002 Vijay Shankar for EnhancementBug# 2427465, FileVersion# 615.2

Line 6570: Created a new variable v_uom_code and passing the same to jai_po_tax_pkg.calculate_tax that will not make a query on po_lines_all

6566: -------------------------------------------------
6567: 1 5/12/2002 Vijay Shankar for Bug# 2695844, FileVersion: 615.1
6568: when making a call to jai_po_tax_pkg.calculate_tax procedure, v_uom is going as NULL and so the procedure is making a call to po_lines_all
6569: table to fetch the uom and which is giving the mutating error.
6570: Created a new variable v_uom_code and passing the same to jai_po_tax_pkg.calculate_tax that will not make a query on po_lines_all
6571:
6572: 2 6/12/2002 Vijay Shankar for EnhancementBug# 2427465, FileVersion# 615.2
6573: tax_category_id column is populated into PO and SO localization tables, which will be used to
6574: identify from which tax_category the taxes are defaulted. Also the tax_category_id populated into the