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

Line 233: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

229: where delivery_detail_id = cp_delivery_Detail_id;
230:
231: cursor c_cess_amount(cp_delivery_id number) is
232: select sum(a.tax_amount)
233: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
234: where delivery_detail_id in
235: (select delivery_detail_id
236: from JAI_OM_WSH_LINES_ALL
237: where delivery_id = cp_delivery_id

Line 246: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

242:
243: /*Bug 5989740 bduvarag start*/
244: cursor c_sh_cess_amount(cp_delivery_id number) is
245: select sum(a.tax_amount)
246: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
247: where delivery_detail_id in
248: (select delivery_detail_id
249: from JAI_OM_WSH_LINES_ALL
250: where delivery_id = cp_delivery_id

Line 660: JAI_CMN_TAXES_ALL jtc

656: */
657: CURSOR c_tax_type_rec IS
658: SELECT jtc.tax_type , round(sum(jsptl.func_tax_amount),0) tax_amount --rchandan for bug#4388950
659: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
660: JAI_CMN_TAXES_ALL jtc
661: WHERE jtc.tax_id = jsptl.tax_id
662: --Modified for bug5747126
663: AND delivery_detail_id = p_delivery_detail_id
664: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436

Line 689: JAI_CMN_TAXES_ALL jtc ,

685: CURSOR c_tax_type_for_delivery_rec IS
686: SELECT jtc.tax_type , round(sum(jsptl.func_tax_amount),0) tax_amount
687: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
688: JAI_OM_WSH_LINES_ALL jspl ,
689: JAI_CMN_TAXES_ALL jtc ,
690: JAI_INV_ITM_SETUPS jmsi /* Added by Ramananda for bug#5912620*/
691: WHERE jtc.tax_id = jsptl.tax_id
692: AND jspl.delivery_id = p_delivery_id
693: AND jspl.delivery_detail_id = jsptl.delivery_detail_id

Line 824: JAI_CMN_TAXES_ALL jtc

820: */
821: CURSOR c_tax_type_rec IS
822: SELECT jtc.tax_type , sum(jrctl.func_tax_amount) tax_amount
823: FROM JAI_AR_TRX_TAX_LINES jrctl ,
824: JAI_CMN_TAXES_ALL jtc
825: WHERE jtc.tax_id = jrctl.tax_id
826: AND link_to_cust_trx_line_id = p_customer_trx_id -- added, aiyer for Bug 4541303 /*Bug 5989740 bduvarag*/
827: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC')
828: OR

Line 1206: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

1202: WHERE delivery_detail_id = cp_delivery_detail_id;
1203:
1204: CURSOR c_cess_amount(cp_delivery_id number) is
1205: SELECT sum(a.tax_amount)
1206: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
1207: WHERE delivery_detail_id in
1208: (SELECt delivery_detail_id
1209: FROM JAI_OM_WSH_LINES_ALL
1210: WHERE delivery_id = cp_delivery_id

Line 3527: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

3523:
3524:
3525: CURSOR c_cess_amount IS
3526: SELECT sum(a.tax_amount)
3527: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3528: WHERE delivery_detail_id = p_reference_line_id
3529: AND a.tax_id = b.tax_id
3530: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
3531: /*Bug 5989740 bduvarag*/

Line 3534: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

3530: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
3531: /*Bug 5989740 bduvarag*/
3532: CURSOR c_sh_cess_amount IS
3533: SELECT sum(a.tax_amount)
3534: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3535: WHERE delivery_detail_id = p_reference_line_id
3536: AND a.tax_id = b.tax_id
3537: AND upper(b.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);
3538:

Line 3981: JAI_CMN_TAXES_ALL jtc

3977: */
3978: cursor c_get_om_cess_amount(cp_delivery_id number) is
3979: select SUM(NVL(jsptl.func_tax_amount,0)) tax_amount --NVL(sum(jsptl.func_tax_amount),0) tax_amount -- added , Ramananda NVL condition for bug #4516577
3980: from JAI_OM_WSH_LINE_TAXES jsptl ,
3981: JAI_CMN_TAXES_ALL jtc
3982: where jtc.tax_id = jsptl.tax_id
3983: and delivery_detail_id in
3984: (select delivery_detail_id
3985: from JAI_OM_WSH_LINES_ALL

Line 3993: JAI_CMN_TAXES_ALL jtc

3989: /*Bug 5989740 bduvarag*/
3990: cursor c_get_om_sh_cess_amount(cp_delivery_id number) is
3991: select NVL(sum(jsptl.func_tax_amount),0) tax_amount
3992: from JAI_OM_WSH_LINE_TAXES jsptl ,
3993: JAI_CMN_TAXES_ALL jtc
3994: where jtc.tax_id = jsptl.tax_id
3995: and delivery_detail_id in
3996: (select delivery_detail_id
3997: from JAI_OM_WSH_LINES_ALL

Line 4006: JAI_CMN_TAXES_ALL jtc

4002:
4003: cursor c_get_ar_cess_amount(cp_customer_trx_id number) is
4004: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4005: from JAI_AR_TRX_TAX_LINES jrctl ,
4006: JAI_CMN_TAXES_ALL jtc
4007: where jtc.tax_id = jrctl.tax_id
4008: and link_to_cust_trx_line_id in
4009: (select customer_trx_line_id
4010: from JAI_AR_TRX_LINES

Line 4018: JAI_CMN_TAXES_ALL jtc

4014: /*Bug 5989740 bduvarag*/
4015: cursor c_get_ar_sh_cess_amount(cp_customer_trx_id number) is
4016: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4017: from JAI_AR_TRX_TAX_LINES jrctl ,
4018: JAI_CMN_TAXES_ALL jtc
4019: where jtc.tax_id = jrctl.tax_id
4020: and link_to_cust_trx_line_id in
4021: (select customer_trx_line_id
4022: from JAI_AR_TRX_LINES

Line 4030: JAI_CMN_TAXES_ALL jtc

4026:
4027: cursor c_ar_cess_ctr(cp_customer_trx_id number) is
4028: select count(1)
4029: from JAI_AR_TRX_TAX_LINES jrctl ,
4030: JAI_CMN_TAXES_ALL jtc
4031: where jtc.tax_id = jrctl.tax_id
4032: and link_to_cust_trx_line_id in
4033: (select customer_trx_line_id
4034: from JAI_AR_TRX_LINES

Line 4042: JAI_CMN_TAXES_ALL jtc

4038: /*Bug 5989740 bduvarag*/
4039: cursor c_ar_sh_cess_ctr(cp_customer_trx_id number) is
4040: select count(1)
4041: from JAI_AR_TRX_TAX_LINES jrctl ,
4042: JAI_CMN_TAXES_ALL jtc
4043: where jtc.tax_id = jrctl.tax_id
4044: and link_to_cust_trx_line_id in
4045: (select customer_trx_line_id
4046: from JAI_AR_TRX_LINES

Line 4139: JAI_CMN_TAXES_ALL jtc

4135: jrctl.precedence_8,
4136: jrctl.precedence_9,
4137: jrctl.precedence_10
4138: from JAI_AR_TRX_TAX_LINES jrctl ,
4139: JAI_CMN_TAXES_ALL jtc
4140: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4141: and jtc.tax_id = jrctl.tax_id
4142: and jtc.tax_type in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS)
4143: )

Line 4204: JAI_CMN_TAXES_ALL jtc

4200: jrctl.precedence_8,
4201: jrctl.precedence_9,
4202: jrctl.precedence_10
4203: from JAI_AR_TRX_TAX_LINES jrctl ,
4204: JAI_CMN_TAXES_ALL jtc
4205: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4206: and jtc.tax_id = jrctl.tax_id
4207: and jtc.tax_type in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess)
4208: )