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_CMN_TAXES_ALL

Line 83: CURSOR EXCISE_CAL_CUR(CP_EXCISE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

79: RETURN NULL;
80: END CF_3FORMULA;
81:
82: FUNCTION CF_4FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
83: CURSOR EXCISE_CAL_CUR(CP_EXCISE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
84: SELECT
85: A.FUNC_TAX_AMOUNT FUNC_AMT,
86: B.TAX_TYPE T_TYPE
87: FROM

Line 89: JAI_CMN_TAXES_ALL B

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
93: ORDER BY

Line 174: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

170: ,0);
171: END CF_6FORMULA;
172:
173: FUNCTION CF_7FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
174: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
175: SELECT
176: A.FUNC_TAX_AMOUNT FUNC_AMT,
177: B.TAX_TYPE T_TYPE
178: FROM

Line 180: JAI_CMN_TAXES_ALL B

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
184: ORDER BY

Line 197: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

193: RETURN V_FREIGHT_AMOUNT;
194: END CF_7FORMULA;
195:
196: FUNCTION CF_8FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
197: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
198: SELECT
199: A.FUNC_TAX_AMOUNT FUNC_AMT,
200: B.TAX_TYPE T_TYPE
201: FROM

Line 203: JAI_CMN_TAXES_ALL B

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
207: ORDER BY

Line 220: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

216: RETURN V_INSURANCE_AMOUNT;
217: END CF_8FORMULA;
218:
219: FUNCTION CF_9FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
220: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
221: SELECT
222: A.FUNC_TAX_AMOUNT FUNC_AMT,
223: B.TAX_TYPE T_TYPE
224: FROM

Line 226: JAI_CMN_TAXES_ALL B

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
230: ORDER BY

Line 243: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

239: RETURN V_CST_AMOUNT;
240: END CF_9FORMULA;
241:
242: FUNCTION CF_10FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
243: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
244: SELECT
245: A.FUNC_TAX_AMOUNT FUNC_AMT,
246: B.TAX_TYPE T_TYPE
247: FROM

Line 249: JAI_CMN_TAXES_ALL B

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
253: ORDER BY

Line 266: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

262: RETURN V_CVD_AMOUNT;
263: END CF_10FORMULA;
264:
265: FUNCTION CF_11FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
266: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
267: SELECT
268: A.FUNC_TAX_AMOUNT FUNC_AMT,
269: B.TAX_TYPE T_TYPE
270: FROM

Line 272: JAI_CMN_TAXES_ALL B

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
276: ORDER BY

Line 289: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

285: RETURN V_CUSTOM_AMOUNT;
286: END CF_11FORMULA;
287:
288: FUNCTION CF_12FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
289: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
290: SELECT
291: A.FUNC_TAX_AMOUNT FUNC_AMT,
292: B.TAX_TYPE T_TYPE
293: FROM

Line 295: JAI_CMN_TAXES_ALL B

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
299: ORDER BY

Line 312: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

308: RETURN V_OCTRAI_AMOUNT;
309: END CF_12FORMULA;
310:
311: FUNCTION CF_13FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
312: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
313: SELECT
314: A.FUNC_TAX_AMOUNT FUNC_AMT,
315: B.TAX_TYPE T_TYPE
316: FROM

Line 318: JAI_CMN_TAXES_ALL B

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
322: ORDER BY

Line 335: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

331: RETURN V_OTHER_AMOUNT;
332: END CF_13FORMULA;
333:
334: FUNCTION CF_14FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
335: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
336: SELECT
337: A.FUNC_TAX_AMOUNT FUNC_AMT,
338: B.TAX_TYPE T_TYPE
339: FROM

Line 341: JAI_CMN_TAXES_ALL B

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
345: ORDER BY

Line 358: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

354: RETURN V_SALES_AMOUNT;
355: END CF_14FORMULA;
356:
357: FUNCTION CF_15FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
358: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
359: SELECT
360: A.FUNC_TAX_AMOUNT FUNC_AMT,
361: B.TAX_TYPE T_TYPE
362: FROM

Line 364: JAI_CMN_TAXES_ALL B

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
368: ORDER BY

Line 381: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

377: RETURN V_SERVICE_AMOUNT;
378: END CF_15FORMULA;
379:
380: FUNCTION CF_16FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
381: CURSOR EXCISE_CAL_CUR(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
382: SELECT
383: A.FUNC_TAX_AMOUNT FUNC_AMT,
384: B.TAX_TYPE T_TYPE
385: FROM

Line 387: JAI_CMN_TAXES_ALL B

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
391: ORDER BY

Line 702: CURSOR GET_TAX_RATE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

698: ,1));
699: END TOT_ASSESSABLE_VALUEFORMULA;
700:
701: FUNCTION BASIC_RATEFORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
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

Line 712: JAI_CMN_TAXES_ALL

708: AND TAX_ID IN (
709: SELECT
710: TAX_ID
711: FROM
712: JAI_CMN_TAXES_ALL
713: WHERE TAX_TYPE LIKE CP_TAX_TYPE );
714: V_TOT_TAX NUMBER := 0;
715: V_AVG_DUTY NUMBER := 0;
716: V_TAX_COUNT NUMBER := 0;

Line 732: CURSOR GET_TAX_RATE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

728: RETURN V_AVG_DUTY;
729: END BASIC_RATEFORMULA;
730:
731: FUNCTION SPECIAL_RATEFORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
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

Line 742: JAI_CMN_TAXES_ALL

738: AND TAX_ID IN (
739: SELECT
740: TAX_ID
741: FROM
742: JAI_CMN_TAXES_ALL
743: WHERE TAX_TYPE LIKE CP_TAX_TYPE );
744: V_TOT_TAX NUMBER := 0;
745: V_AVG_DUTY NUMBER := 0;
746: V_TAX_COUNT NUMBER := 0;

Line 762: CURSOR GET_TAX_RATE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

758: RETURN V_AVG_DUTY;
759: END SPECIAL_RATEFORMULA;
760:
761: FUNCTION ADDL_RATEFORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
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

Line 772: JAI_CMN_TAXES_ALL

768: AND TAX_ID IN (
769: SELECT
770: TAX_ID
771: FROM
772: JAI_CMN_TAXES_ALL
773: WHERE TAX_TYPE LIKE CP_TAX_TYPE );
774: V_TOT_TAX NUMBER := 0;
775: V_AVG_DUTY NUMBER := 0;
776: V_TAX_COUNT NUMBER := 0;

Line 862: CURSOR FOR_MODVAT_TAX_RATE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS

858: WHERE ORGANIZATION_ID = CF_24FORMULA.ORGANIZATION_ID
859: AND NVL(LOCATION_ID
860: ,0) = NVL(LOCATION_ID
861: ,0);
862: CURSOR FOR_MODVAT_TAX_RATE(CP_TAX_TYPE IN JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE) IS
863: SELECT
864: A.TAX_RATE,
865: B.ROUNDING_FACTOR
866: FROM

Line 868: JAI_CMN_TAXES_ALL B

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;
872: CURSOR ITEM_CLASS_CUR IS