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

Line 420: JAI_CMN_TAXES_ALL JTC

416: JSPTL.TAX_RATE CESS_RATE
417: FROM
418: JAI_OM_WSH_LINES_ALL JSPL,
419: JAI_OM_WSH_LINE_TAXES JSPTL,
420: JAI_CMN_TAXES_ALL JTC
421: WHERE JSPL.DELIVERY_DETAIL_ID = JSPTL.DELIVERY_DETAIL_ID
422: AND JSPTL.TAX_ID = JTC.TAX_ID
423: AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' )
424: AND JSPL.DELIVERY_DETAIL_ID = REF_DOC_NO;

Line 431: JAI_CMN_TAXES_ALL JTC

427: JRCTTL.TAX_RATE CESS_RATE
428: FROM
429: JAI_AR_TRX_LINES JRCTL,
430: JAI_AR_TRX_TAX_LINES JRCTTL,
431: JAI_CMN_TAXES_ALL JTC
432: WHERE JRCTL.CUSTOMER_TRX_LINE_ID = JRCTTL.LINK_TO_CUST_TRX_LINE_ID
433: AND JRCTTL.TAX_ID = JTC.TAX_ID
434: AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_EDUCATION_CESS' , 'CVD_EDUCATION_CESS' )
435: AND JRCTL.CUSTOMER_TRX_ID = REF_DOC_NO;

Line 510: JAI_CMN_TAXES_ALL JTC

506: JSPTL.TAX_RATE CESS_RATE
507: FROM
508: JAI_OM_WSH_LINES_ALL JSPL,
509: JAI_OM_WSH_LINE_TAXES JSPTL,
510: JAI_CMN_TAXES_ALL JTC
511: WHERE JSPL.DELIVERY_DETAIL_ID = JSPTL.DELIVERY_DETAIL_ID
512: AND JSPTL.TAX_ID = JTC.TAX_ID
513: AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' )
514: AND JSPL.DELIVERY_DETAIL_ID = REF_DOC_NO;

Line 521: JAI_CMN_TAXES_ALL JTC

517: JRCTTL.TAX_RATE CESS_RATE
518: FROM
519: JAI_AR_TRX_LINES JRCTL,
520: JAI_AR_TRX_TAX_LINES JRCTTL,
521: JAI_CMN_TAXES_ALL JTC
522: WHERE JRCTL.CUSTOMER_TRX_LINE_ID = JRCTTL.LINK_TO_CUST_TRX_LINE_ID
523: AND JRCTTL.TAX_ID = JTC.TAX_ID
524: AND UPPER(JTC.TAX_TYPE) IN ( 'EXCISE_SH_EDU_CESS' , 'CVD_SH_EDU_CESS' )
525: AND JRCTL.CUSTOMER_TRX_ID = REF_DOC_NO;