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.JA_JAINTSLS_XMLP_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 71: JAI_AR_TRX_TAX_LINES JRCTAXL,

67: RA_CUSTOMER_TRX_ALL CUTX,
68: JAI_AR_TRXS JCUTX,
69: RA_CUSTOMER_TRX_LINES_ALL CUTXL,
70: JAI_CMN_CUS_ADDRESSES JCUAD,
71: JAI_AR_TRX_TAX_LINES JRCTAXL,
72: JAI_CMN_TAXES_ALL JITC,
73: AR_PAYMENT_SCHEDULES_ALL ARPS
74: WHERE JCUTX.ORGANIZATION_ID = P_ORGANIZATION_ID
75: AND CUTX.CUSTOMER_TRX_ID = JCUTX.CUSTOMER_TRX_ID

Line 107: JAI_AR_TRX_TAX_LINES A,

103: SELECT
104: SUM(A.TAX_AMOUNT)
105: INTO EXCISE_TAX
106: FROM
107: JAI_AR_TRX_TAX_LINES A,
108: JAI_CMN_TAXES_ALL B
109: WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_1FORMULA0004.CUSTOMER_TRX_LINE_ID
110: AND A.TAX_ID = B.TAX_ID
111: AND UPPER(B.TAX_TYPE) IN ( LV_EXCISE , LV_ADDL_EXCISE , LV_OTHER_EXCISE , LV_EXC_EDU_CESS , LV_SH_EXC_EDU_CESS );

Line 141: JAI_AR_TRX_TAX_LINES A,

137: SELECT
138: SUM(A.TAX_AMOUNT)
139: INTO OTHER_TAX
140: FROM
141: JAI_AR_TRX_TAX_LINES A,
142: JAI_CMN_TAXES_ALL B
143: WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_2FORMULA.CUSTOMER_TRX_LINE_ID
144: AND A.TAX_ID = B.TAX_ID
145: AND UPPER(B.TAX_TYPE) NOT IN ( LV_EXCISE , LV_ADDL_EXCISE , LV_OTHER_EXCISE , LV_EXC_EDU_CESS , LV_SALES_TAX , LV_CST , LV_SH_EXC_EDU_CESS );

Line 285: JAI_AR_TRX_TAX_LINES A,

281: SELECT
282: SUM(A.FUNC_TAX_AMOUNT)
283: INTO VAT_TAX
284: FROM
285: JAI_AR_TRX_TAX_LINES A,
286: JAI_CMN_TAXES_ALL B
287: WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_VAT_TAXES_1.CUSTOMER_TRX_LINE_ID
288: AND A.TAX_ID = B.TAX_ID
289: AND UPPER(B.TAX_TYPE) IN (