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_JAINVAR_XMLP_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 88: JAI_AR_TRX_TAX_LINES A,

84: SELECT
85: A.FUNC_TAX_AMOUNT FUNC_AMT,
86: B.TAX_TYPE T_TYPE
87: FROM
88: JAI_AR_TRX_TAX_LINES A,
89: JAI_CMN_TAXES_ALL B
90: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_4FORMULA.CUSTOMER_TRX_LINE_ID
91: AND A.TAX_ID = B.TAX_ID
92: AND B.TAX_TYPE = CP_EXCISE

Line 179: JAI_AR_TRX_TAX_LINES A,

175: SELECT
176: A.FUNC_TAX_AMOUNT FUNC_AMT,
177: B.TAX_TYPE T_TYPE
178: FROM
179: JAI_AR_TRX_TAX_LINES A,
180: JAI_CMN_TAXES_ALL B
181: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_7FORMULA.CUSTOMER_TRX_LINE_ID
182: AND A.TAX_ID = B.TAX_ID
183: AND B.TAX_TYPE = CP_TAX_TYPE

Line 202: JAI_AR_TRX_TAX_LINES A,

198: SELECT
199: A.FUNC_TAX_AMOUNT FUNC_AMT,
200: B.TAX_TYPE T_TYPE
201: FROM
202: JAI_AR_TRX_TAX_LINES A,
203: JAI_CMN_TAXES_ALL B
204: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_8FORMULA.CUSTOMER_TRX_LINE_ID
205: AND A.TAX_ID = B.TAX_ID
206: AND B.TAX_TYPE = CP_TAX_TYPE

Line 225: JAI_AR_TRX_TAX_LINES A,

221: SELECT
222: A.FUNC_TAX_AMOUNT FUNC_AMT,
223: B.TAX_TYPE T_TYPE
224: FROM
225: JAI_AR_TRX_TAX_LINES A,
226: JAI_CMN_TAXES_ALL B
227: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_9FORMULA.CUSTOMER_TRX_LINE_ID
228: AND A.TAX_ID = B.TAX_ID
229: AND B.TAX_TYPE = CP_TAX_TYPE

Line 248: JAI_AR_TRX_TAX_LINES A,

244: SELECT
245: A.FUNC_TAX_AMOUNT FUNC_AMT,
246: B.TAX_TYPE T_TYPE
247: FROM
248: JAI_AR_TRX_TAX_LINES A,
249: JAI_CMN_TAXES_ALL B
250: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_10FORMULA.CUSTOMER_TRX_LINE_ID
251: AND A.TAX_ID = B.TAX_ID
252: AND B.TAX_TYPE = CP_TAX_TYPE

Line 271: JAI_AR_TRX_TAX_LINES A,

267: SELECT
268: A.FUNC_TAX_AMOUNT FUNC_AMT,
269: B.TAX_TYPE T_TYPE
270: FROM
271: JAI_AR_TRX_TAX_LINES A,
272: JAI_CMN_TAXES_ALL B
273: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_11FORMULA.CUSTOMER_TRX_LINE_ID
274: AND A.TAX_ID = B.TAX_ID
275: AND B.TAX_TYPE = CP_TAX_TYPE

Line 294: JAI_AR_TRX_TAX_LINES A,

290: SELECT
291: A.FUNC_TAX_AMOUNT FUNC_AMT,
292: B.TAX_TYPE T_TYPE
293: FROM
294: JAI_AR_TRX_TAX_LINES A,
295: JAI_CMN_TAXES_ALL B
296: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_12FORMULA.CUSTOMER_TRX_LINE_ID
297: AND A.TAX_ID = B.TAX_ID
298: AND B.TAX_TYPE = CP_TAX_TYPE

Line 317: JAI_AR_TRX_TAX_LINES A,

313: SELECT
314: A.FUNC_TAX_AMOUNT FUNC_AMT,
315: B.TAX_TYPE T_TYPE
316: FROM
317: JAI_AR_TRX_TAX_LINES A,
318: JAI_CMN_TAXES_ALL B
319: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_13FORMULA.CUSTOMER_TRX_LINE_ID
320: AND A.TAX_ID = B.TAX_ID
321: AND B.TAX_TYPE = CP_TAX_TYPE

Line 340: JAI_AR_TRX_TAX_LINES A,

336: SELECT
337: A.FUNC_TAX_AMOUNT FUNC_AMT,
338: B.TAX_TYPE T_TYPE
339: FROM
340: JAI_AR_TRX_TAX_LINES A,
341: JAI_CMN_TAXES_ALL B
342: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_14FORMULA.CUSTOMER_TRX_LINE_ID
343: AND A.TAX_ID = B.TAX_ID
344: AND B.TAX_TYPE = CP_TAX_TYPE

Line 363: JAI_AR_TRX_TAX_LINES A,

359: SELECT
360: A.FUNC_TAX_AMOUNT FUNC_AMT,
361: B.TAX_TYPE T_TYPE
362: FROM
363: JAI_AR_TRX_TAX_LINES A,
364: JAI_CMN_TAXES_ALL B
365: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_15FORMULA.CUSTOMER_TRX_LINE_ID
366: AND A.TAX_ID = B.TAX_ID
367: AND B.TAX_TYPE = CP_TAX_TYPE

Line 386: JAI_AR_TRX_TAX_LINES A,

382: SELECT
383: A.FUNC_TAX_AMOUNT FUNC_AMT,
384: B.TAX_TYPE T_TYPE
385: FROM
386: JAI_AR_TRX_TAX_LINES A,
387: JAI_CMN_TAXES_ALL B
388: WHERE LINK_TO_CUST_TRX_LINE_ID = CF_16FORMULA.CUSTOMER_TRX_LINE_ID
389: AND A.TAX_ID = B.TAX_ID
390: AND B.TAX_TYPE = CP_TAX_TYPE

Line 706: JAI_AR_TRX_TAX_LINES

702: CURSOR GET_TAX_RATE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
703: SELECT
704: TAX_RATE
705: FROM
706: JAI_AR_TRX_TAX_LINES
707: WHERE LINK_TO_CUST_TRX_LINE_ID = BASIC_RATEFORMULA.CUSTOMER_TRX_LINE_ID
708: AND TAX_ID IN (
709: SELECT
710: TAX_ID

Line 736: JAI_AR_TRX_TAX_LINES

732: CURSOR GET_TAX_RATE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
733: SELECT
734: TAX_RATE
735: FROM
736: JAI_AR_TRX_TAX_LINES
737: WHERE LINK_TO_CUST_TRX_LINE_ID = SPECIAL_RATEFORMULA.CUSTOMER_TRX_LINE_ID
738: AND TAX_ID IN (
739: SELECT
740: TAX_ID

Line 766: JAI_AR_TRX_TAX_LINES

762: CURSOR GET_TAX_RATE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
763: SELECT
764: TAX_RATE
765: FROM
766: JAI_AR_TRX_TAX_LINES
767: WHERE LINK_TO_CUST_TRX_LINE_ID = ADDL_RATEFORMULA.CUSTOMER_TRX_LINE_ID
768: AND TAX_ID IN (
769: SELECT
770: TAX_ID

Line 867: JAI_AR_TRX_TAX_LINES A,

863: SELECT
864: A.TAX_RATE,
865: B.ROUNDING_FACTOR
866: FROM
867: JAI_AR_TRX_TAX_LINES A,
868: JAI_CMN_TAXES_ALL B
869: WHERE A.TAX_ID = B.TAX_ID
870: AND A.LINK_TO_CUST_TRX_LINE_ID = CF_24FORMULA.CUSTOMER_TRX_LINE_ID
871: AND B.TAX_TYPE = CP_TAX_TYPE;