eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_TAX_PKG dependencies on JAI_PO_TAXES

Line 377: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,

373:
374:
375:
376: TYPE PO_TAX_CUR IS RECORD(
377: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
378: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
379: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
381: Uom JAI_PO_TAXES.UOM%TYPE,

Line 378: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

374:
375:
376: TYPE PO_TAX_CUR IS RECORD(
377: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
378: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
379: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
381: Uom JAI_PO_TAXES.UOM%TYPE,
382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,

Line 379: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

375:
376: TYPE PO_TAX_CUR IS RECORD(
377: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
378: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
379: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
381: Uom JAI_PO_TAXES.UOM%TYPE,
382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,

Line 380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

376: TYPE PO_TAX_CUR IS RECORD(
377: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
378: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
379: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
381: Uom JAI_PO_TAXES.UOM%TYPE,
382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,

Line 381: Uom JAI_PO_TAXES.UOM%TYPE,

377: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
378: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
379: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
381: Uom JAI_PO_TAXES.UOM%TYPE,
382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,

Line 382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,

378: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
379: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
381: Uom JAI_PO_TAXES.UOM%TYPE,
382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,

Line 383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,

379: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
381: Uom JAI_PO_TAXES.UOM%TYPE,
382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,

Line 385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,

381: Uom JAI_PO_TAXES.UOM%TYPE,
382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
389: currency JAI_PO_TAXES.currency%type,

Line 389: currency JAI_PO_TAXES.currency%type,

385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
389: currency JAI_PO_TAXES.currency%type,
390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,

Line 392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,

388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
389: currency JAI_PO_TAXES.currency%type,
390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

Line 393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,

389: currency JAI_PO_TAXES.currency%type,
390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
397: regime_code varchar2(30),

Line 394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,

390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
397: regime_code varchar2(30),
398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

Line 395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
397: regime_code varchar2(30),
398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
399: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,

Line 396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
397: regime_code varchar2(30),
398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
399: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
400: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,

Line 398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
397: regime_code varchar2(30),
398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
399: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
400: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
401: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
402: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE

Line 399: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,

395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
397: regime_code varchar2(30),
398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
399: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
400: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
401: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
402: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE
403: );

Line 400: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,

396: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
397: regime_code varchar2(30),
398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
399: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
400: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
401: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
402: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE
403: );
404: TYPE tax_cur_type IS REF CURSOR RETURN PO_TAX_CUR;

Line 401: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,

397: regime_code varchar2(30),
398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
399: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
400: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
401: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
402: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE
403: );
404: TYPE tax_cur_type IS REF CURSOR RETURN PO_TAX_CUR;
405: c_po_tax_cur TAX_CUR_TYPE;

Line 402: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE

398: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
399: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
400: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
401: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
402: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE
403: );
404: TYPE tax_cur_type IS REF CURSOR RETURN PO_TAX_CUR;
405: c_po_tax_cur TAX_CUR_TYPE;
406: po_lines_rec c_po_tax_cur%rowtype;

Line 924: of Tax related Information from JAI_PO_TAXES

920: Changed the Insert of JAI_RCV_LINES with 2 columns ( organization_id,transaction_id).
921:
922: 2. For Bug # 2808110
923: Added an Order by Clause in the Fetching
924: of Tax related Information from JAI_PO_TAXES
925: as this is very critical in the Precedence Logic Incorporated.
926:
927: 3. For Bug # 2798999 - Generic Fix for the One Off Patch.
928: Added the call to jai_rcv_utils_pkg.get_organization_id

Line 1089: PO JAI_PO_TAXES

1085: The code now fetches the Precedences from the following points for the following sources:
1086: ----------------------------------------------------------------------------------------
1087: source type Source Table
1088: RMA JAI_OM_OE_RMA_TAXES
1089: PO JAI_PO_TAXES
1090: ISO JAI_OM_WSH_LINE_TAXES
1091: ----------------------------------------------------------------------------------------
1092: In these 3 cases a insert into JAI_RCV_LINE_TAXES is present and this is,
1093: changed to incorporate precedences as well as transaction id.

Line 1250: 1) In the cursor for selecting the taxes from JAI_PO_TAXES,

1246: System is creating receiving accounting entry and generating tax invoice against disable taxes
1247:
1248: Fix
1249: ---
1250: 1) In the cursor for selecting the taxes from JAI_PO_TAXES,
1251: changed the columns tax_rate, qty_rate and tax_amount
1252:
1253: Dependency due to this Bug-
1254: None

Line 2090: FROM JAI_PO_TAXES llt,

2086: llt.precedence_7,
2087: llt.precedence_8,
2088: llt.precedence_9,
2089: llt.precedence_10
2090: FROM JAI_PO_TAXES llt,
2091: JAI_CMN_TAXES_ALL jtc
2092: , jai_regime_tax_types_v tax_types
2093: WHERE line_location_id = p_line_location_id
2094: AND jtc.tax_id = llt.tax_id