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_AR_SUP_TRX_PKG dependencies on JAI_CMN_TAXES_ALL

Line 500: old_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/

496: p_mapping_id NUMBER;
497: a_mapping_id NUMBER;
498: new_tax_excise NUMBER := 0;
499: old_tax_excise NUMBER := 0;
500: old_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/
501: new_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/
502: old_tax_other NUMBER := 0;
503: new_tax_other NUMBER := 0;
504: old_tax_amount NUMBER := 0;

Line 501: new_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/

497: a_mapping_id NUMBER;
498: new_tax_excise NUMBER := 0;
499: old_tax_excise NUMBER := 0;
500: old_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/
501: new_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ; /* Modified by aiyer for the bug 5378631*/
502: old_tax_other NUMBER := 0;
503: new_tax_other NUMBER := 0;
504: old_tax_amount NUMBER := 0;
505: new_tax_amount NUMBER := 0;

Line 1369: JAI_CMN_TAXES_ALL COD

1365: TEMP.PRECEDENCE_9,
1366: TEMP.PRECEDENCE_10,
1367: COD.ADHOC_FLAG
1368: FROM JAI_AR_TRX_TAX_CALC_T TEMP,
1369: JAI_CMN_TAXES_ALL COD
1370: WHERE LINK_TO_CUST_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID
1371: AND TEMP.TAX_ID = COD.TAX_ID;
1372:
1373: CURSOR GET_INV_TAX IS

Line 1461: TAX_RATE = (SELECT TAX_RATE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID),

1457: TAX_LIST_CHANGE_INDICATOR := 'Y';
1458: v_statement_id := '60';
1459: UPDATE JAI_AR_TRX_TAX_CALC_T
1460: SET TAX_ID = CTAX.NEW_TYPE_ID,
1461: TAX_RATE = (SELECT TAX_RATE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID),
1462: UOM = (SELECT UOM FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID)
1463: WHERE TAX_ID = CTAX.EXISTING_TYPE_ID;
1464: END IF;
1465:

Line 1462: UOM = (SELECT UOM FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID)

1458: v_statement_id := '60';
1459: UPDATE JAI_AR_TRX_TAX_CALC_T
1460: SET TAX_ID = CTAX.NEW_TYPE_ID,
1461: TAX_RATE = (SELECT TAX_RATE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID),
1462: UOM = (SELECT UOM FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = CTAX.NEW_TYPE_ID)
1463: WHERE TAX_ID = CTAX.EXISTING_TYPE_ID;
1464: END IF;
1465:
1466: END LOOP;

Line 1710: SELECT TAX_TYPE INTO OLD_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = A.TAX_ID;

1706: v_statement_id := '84';
1707: IF A.TAX_LINE_NO = B.TAX_LINE_NO THEN
1708:
1709: v_statement_id := '85';
1710: SELECT TAX_TYPE INTO OLD_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = A.TAX_ID;
1711:
1712: v_statement_id := '86';
1713: SELECT TAX_TYPE INTO NEW_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = B.TAX_ID;
1714:

Line 1713: SELECT TAX_TYPE INTO NEW_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = B.TAX_ID;

1709: v_statement_id := '85';
1710: SELECT TAX_TYPE INTO OLD_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = A.TAX_ID;
1711:
1712: v_statement_id := '86';
1713: SELECT TAX_TYPE INTO NEW_TAX_TYPE FROM JAI_CMN_TAXES_ALL WHERE TAX_ID = B.TAX_ID;
1714:
1715: IF OLD_TAX_TYPE LIKE '%Excise%' THEN
1716: v_statement_id := '87';
1717: UPDATE JAI_AR_SUP_LINES

Line 2566: JAI_CMN_TAXES_ALL d

2562: ) tax_type_val,
2563: d.inclusive_tax_flag -- Added by Jia Li for Tax Inclusive Computations on 2007/12/07
2564: FROM
2565: JAI_AR_TRX_TAX_CALC_T c,
2566: JAI_CMN_TAXES_ALL d
2567: WHERE
2568: c.link_to_cust_trx_line_id = p_line_id AND
2569: c.tax_id = d.tax_id
2570: ORDER BY