DBA Data[Home] [Help]

APPS.JAI_PO_TAX_PKG dependencies on PO_LINES_ALL

Line 270: FROM Po_Lines_All

266: --Add by Eric Ma for Retro Active Pricing Update on Jan 11, 2008 ,End
267:
268: CURSOR Fetch_Item_Cur IS
269: SELECT Item_Id
270: FROM Po_Lines_All
271: WHERE Po_Line_Id = p_line_id;
272:
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

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

3180: FROM Po_Line_Locations_all
3181: WHERE Po_Header_Id = v_po_hdr_id;
3182:
3183: CURSOR Fetch_Item_Cur( Lineid IN NUMBER ) IS SELECT Item_Id
3184: FROM Po_Lines_All
3185: WHERE Po_Line_Id = Lineid;
3186:
3187: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS SELECT Line_Location_Id
3188: FROM po_line_locations_all

Line 3194: FROM Po_Lines_All

3190:
3191: ------------------------------ ------------------------------ ------------------------------ ------------------------------
3192:
3193: CURSOR Fetch_Dtls_Cur( lineid IN NUMBER ) IS SELECT Quantity, Unit_Price, Unit_Meas_Lookup_Code
3194: FROM Po_Lines_All
3195: WHERE Po_Line_Id = lineid;
3196:
3197: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS SELECT Quantity, Price_Override,
3198: Unit_Meas_Lookup_Code

Line 3609: FROM po_lines_all

3605: */
3606:
3607: CURSOR fetch_item_cur IS
3608: SELECT item_id
3609: FROM po_lines_all
3610: WHERE po_line_id = p_line_id;
3611: /* Added by LGOPALSA. Bug 4210102.
3612: Added CVD and Excise education cess
3613: */

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

6550:
6551: CURSOR Fetch_Line_Loc_Id_Cur IS
6552: SELECT jpll.Line_Location_Id
6553: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
6554: po_lines_all pla, po_headers_all pha
6555: WHERE pha.po_header_id = pla.po_header_id
6556: AND jpll.line_location_id = plla.line_location_id
6557: AND pha.po_header_id = plla.po_header_id
6558: AND pla.po_line_id = plla.po_line_id

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

6560: AND pla.line_num = p_line_num
6561: AND pla.item_id = p_item_id
6562: AND plla.shipment_num = p_ship_num;
6563:
6564: -- Cursor definition for picking po_line_id from po_lines_all
6565: CURSOR fetch_line_id_cur IS
6566: SELECT pla.Po_Line_Id
6567: FROM po_lines_all pla, po_headers_all pha
6568: WHERE pha.Po_Header_Id = p_from_hdr_id

Line 6567: FROM po_lines_all pla, po_headers_all pha

6563:
6564: -- Cursor definition for picking po_line_id from po_lines_all
6565: CURSOR fetch_line_id_cur IS
6566: SELECT pla.Po_Line_Id
6567: FROM po_lines_all pla, po_headers_all pha
6568: WHERE pha.Po_Header_Id = p_from_hdr_id
6569: AND pla.line_num = p_line_num -- Vijay Shankar for Bug# 3466223
6570: AND pha.po_header_id =pla.po_header_id;
6571:

Line 6947: FROM po_lines_all

6943:
6944: CURSOR cur_item
6945: IS
6946: SELECT ITEM_ID
6947: FROM po_lines_all
6948: WHERE po_line_id = p_po_line_id;
6949:
6950: lv_item_id po_lines_all.item_id%type;
6951:

Line 6950: lv_item_id po_lines_all.item_id%type;

6946: SELECT ITEM_ID
6947: FROM po_lines_all
6948: WHERE po_line_id = p_po_line_id;
6949:
6950: lv_item_id po_lines_all.item_id%type;
6951:
6952: vendor_rec cur_vendor%ROWTYPE;
6953: v_check_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --Nagaraj.s for Bug2953445.
6954: v_tax_amount NUMBER;--Nagaraj.s for Bug2953445.

Line 7321: FROM Po_Lines_All

7317: AND line_location_id=p_line_loc_id;
7318:
7319: CURSOR Fetch_Lineid_Cur IS
7320: SELECT Po_Line_Id, Unit_Price, Unit_Meas_Lookup_Code, Item_Id
7321: FROM Po_Lines_All
7322: WHERE Po_Line_Id = p_line_id;
7323:
7324: CURSOR Fetch_UOMCode_Cur( uom IN VARCHAR2 ) IS
7325: SELECT Uom_Code

Line 7342: FROM Po_Lines_All

7338: WHERE Po_Header_Id = v_po_hdr_id;
7339:
7340: CURSOR Get_Item_Id_Cur IS
7341: SELECT Item_Id
7342: FROM Po_Lines_All
7343: WHERE Po_Line_Id = v_po_line_id;
7344:
7345: -- added by Vijay Shankar for Bug# 3487904
7346: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS

Line 8048: 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

8044: CHANGE HISTORY for FILENAME - ja_in_po_default_taxes_pkg.sql
8045: S.No Date Author and Details
8046: -------------------------------------------------
8047: 1 5/12/2002 Vijay Shankar for Bug# 2695844, FileVersion: 615.1
8048: 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
8049: table to fetch the uom and which is giving the mutating error.
8050: 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
8051:
8052: 2 6/12/2002 Vijay Shankar for EnhancementBug# 2427465, FileVersion# 615.2

Line 8050: 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

8046: -------------------------------------------------
8047: 1 5/12/2002 Vijay Shankar for Bug# 2695844, FileVersion: 615.1
8048: 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
8049: table to fetch the uom and which is giving the mutating error.
8050: 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
8051:
8052: 2 6/12/2002 Vijay Shankar for EnhancementBug# 2427465, FileVersion# 615.2
8053: tax_category_id column is populated into PO and SO localization tables, which will be used to
8054: identify from which tax_category the taxes are defaulted. Also the tax_category_id populated into the