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 399: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,

395:
396:
397:
398: TYPE PO_TAX_CUR IS RECORD(
399: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
400: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
401: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
403: Uom JAI_PO_TAXES.UOM%TYPE,

Line 400: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,

396:
397:
398: TYPE PO_TAX_CUR IS RECORD(
399: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
400: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
401: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
403: Uom JAI_PO_TAXES.UOM%TYPE,
404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,

Line 401: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,

397:
398: TYPE PO_TAX_CUR IS RECORD(
399: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
400: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
401: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
403: Uom JAI_PO_TAXES.UOM%TYPE,
404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,

Line 402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,

398: TYPE PO_TAX_CUR IS RECORD(
399: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
400: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
401: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
403: Uom JAI_PO_TAXES.UOM%TYPE,
404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,

Line 403: Uom JAI_PO_TAXES.UOM%TYPE,

399: tax_line_no JAI_PO_TAXES.TAX_LINE_NO%TYPE,
400: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
401: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
403: Uom JAI_PO_TAXES.UOM%TYPE,
404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,

Line 404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,

400: Tax_Id JAI_PO_TAXES.TAX_ID%TYPE,
401: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
403: Uom JAI_PO_TAXES.UOM%TYPE,
404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,

Line 405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,

401: Tax_rate JAI_PO_TAXES.TAX_RATE%TYPE,
402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
403: Uom JAI_PO_TAXES.UOM%TYPE,
404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,

Line 407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,

403: Uom JAI_PO_TAXES.UOM%TYPE,
404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
411: currency JAI_PO_TAXES.currency%type,

Line 411: currency JAI_PO_TAXES.currency%type,

407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
411: currency JAI_PO_TAXES.currency%type,
412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,

Line 414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,

410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
411: currency JAI_PO_TAXES.currency%type,
412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

Line 415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,

411: currency JAI_PO_TAXES.currency%type,
412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
419: regime_code varchar2(30),

Line 416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,

412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
419: regime_code varchar2(30),
420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

Line 417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
419: regime_code varchar2(30),
420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
421: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,

Line 418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,

414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
419: regime_code varchar2(30),
420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
421: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
422: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,

Line 420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,

416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
419: regime_code varchar2(30),
420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
421: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
422: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
423: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
424: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE

Line 421: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,

417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,
418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
419: regime_code varchar2(30),
420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
421: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
422: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
423: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
424: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE
425: );

Line 422: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,

418: Precedence_5 JAI_PO_TAXES.PRECEDENCE_5%TYPE,
419: regime_code varchar2(30),
420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
421: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
422: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
423: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
424: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE
425: );
426: TYPE tax_cur_type IS REF CURSOR RETURN PO_TAX_CUR;

Line 423: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,

419: regime_code varchar2(30),
420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
421: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
422: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
423: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
424: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE
425: );
426: TYPE tax_cur_type IS REF CURSOR RETURN PO_TAX_CUR;
427: c_po_tax_cur TAX_CUR_TYPE;

Line 424: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE

420: Precedence_6 JAI_PO_TAXES.PRECEDENCE_6%TYPE,
421: Precedence_7 JAI_PO_TAXES.PRECEDENCE_7%TYPE,
422: Precedence_8 JAI_PO_TAXES.PRECEDENCE_8%TYPE,
423: Precedence_9 JAI_PO_TAXES.PRECEDENCE_9%TYPE,
424: Precedence_10 JAI_PO_TAXES.PRECEDENCE_10%TYPE
425: );
426: TYPE tax_cur_type IS REF CURSOR RETURN PO_TAX_CUR;
427: c_po_tax_cur TAX_CUR_TYPE;
428: po_lines_rec c_po_tax_cur%rowtype;

Line 1016: of Tax related Information from JAI_PO_TAXES

1012: Changed the Insert of JAI_RCV_LINES with 2 columns ( organization_id,transaction_id).
1013:
1014: 2. For Bug # 2808110
1015: Added an Order by Clause in the Fetching
1016: of Tax related Information from JAI_PO_TAXES
1017: as this is very critical in the Precedence Logic Incorporated.
1018:
1019: 3. For Bug # 2798999 - Generic Fix for the One Off Patch.
1020: Added the call to jai_rcv_utils_pkg.get_organization_id

Line 1181: PO JAI_PO_TAXES

1177: The code now fetches the Precedences from the following points for the following sources:
1178: ----------------------------------------------------------------------------------------
1179: source type Source Table
1180: RMA JAI_OM_OE_RMA_TAXES
1181: PO JAI_PO_TAXES
1182: ISO JAI_OM_WSH_LINE_TAXES
1183: ----------------------------------------------------------------------------------------
1184: In these 3 cases a insert into JAI_RCV_LINE_TAXES is present and this is,
1185: changed to incorporate precedences as well as transaction id.

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

1338: System is creating receiving accounting entry and generating tax invoice against disable taxes
1339:
1340: Fix
1341: ---
1342: 1) In the cursor for selecting the taxes from JAI_PO_TAXES,
1343: changed the columns tax_rate, qty_rate and tax_amount
1344:
1345: Dependency due to this Bug-
1346: None

Line 2344: FROM JAI_PO_TAXES llt,

2340: llt.precedence_7,
2341: llt.precedence_8,
2342: llt.precedence_9,
2343: llt.precedence_10
2344: FROM JAI_PO_TAXES llt,
2345: JAI_CMN_TAXES_ALL jtc
2346: , jai_regime_tax_types_v tax_types
2347: WHERE line_location_id = p_line_location_id
2348: AND jtc.tax_id = llt.tax_id