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 272: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

268: where delivery_detail_id = cp_delivery_Detail_id;
269:
270: cursor c_cess_amount(cp_delivery_id number) is
271: select sum(a.tax_amount)
272: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
273: where delivery_detail_id in
274: (select delivery_detail_id
275: from JAI_OM_WSH_LINES_ALL
276: where delivery_id = cp_delivery_id

Line 285: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

281:
282: /*Bug 5989740 bduvarag start*/
283: cursor c_sh_cess_amount(cp_delivery_id number) is
284: select sum(a.tax_amount)
285: from JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
286: where delivery_detail_id in
287: (select delivery_detail_id
288: from JAI_OM_WSH_LINES_ALL
289: where delivery_id = cp_delivery_id

Line 700: JAI_CMN_TAXES_ALL jtc

696: */
697: CURSOR c_tax_type_rec IS
698: SELECT jtc.tax_type , sum(jsptl.func_tax_amount) tax_amount --rchandan for bug#4388950 /*Removed rounding factor by mmurtuza for bug 16534065*/
699: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
700: JAI_CMN_TAXES_ALL jtc
701: WHERE jtc.tax_id = jsptl.tax_id
702: --Modified for bug5747126
703: AND delivery_detail_id = p_delivery_detail_id
704: 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 729: JAI_CMN_TAXES_ALL jtc ,

725: CURSOR c_tax_type_for_delivery_rec IS
726: SELECT jtc.tax_type , sum(jsptl.func_tax_amount) tax_amount /*Removed rounding factor by mmurtuza for bug 16534065*/
727: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
728: JAI_OM_WSH_LINES_ALL jspl ,
729: JAI_CMN_TAXES_ALL jtc ,
730: JAI_INV_ITM_SETUPS jmsi /* Added by Ramananda for bug#5912620*/
731: WHERE jtc.tax_id = jsptl.tax_id
732: AND jspl.delivery_id = p_delivery_id
733: AND jspl.delivery_detail_id = jsptl.delivery_detail_id

Line 870: JAI_CMN_TAXES_ALL jtc

866: */
867: CURSOR c_tax_type_rec IS
868: SELECT jtc.tax_type , sum(jrctl.func_tax_amount) tax_amount --added round for bug#9539924 /*Removed rounding factor by mmurtuza for bug 16534065*/
869: FROM JAI_AR_TRX_TAX_LINES jrctl ,
870: JAI_CMN_TAXES_ALL jtc
871: WHERE jtc.tax_id = jrctl.tax_id
872: AND link_to_cust_trx_line_id = p_customer_trx_id -- added, aiyer for Bug 4541303 /*Bug 5989740 bduvarag*/
873: 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')
874: OR

Line 1252: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

1248: WHERE delivery_detail_id = cp_delivery_detail_id;
1249:
1250: CURSOR c_cess_amount(cp_delivery_id number) is
1251: SELECT sum(a.tax_amount)
1252: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
1253: WHERE delivery_detail_id in
1254: (SELECt delivery_detail_id
1255: FROM JAI_OM_WSH_LINES_ALL
1256: WHERE delivery_id = cp_delivery_id

Line 3826: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

3822:
3823:
3824: CURSOR c_cess_amount IS
3825: SELECT sum(a.tax_amount)
3826: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3827: WHERE delivery_detail_id = p_reference_line_id
3828: AND a.tax_id = b.tax_id
3829: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
3830: /*Bug 5989740 bduvarag*/

Line 3833: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

3829: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
3830: /*Bug 5989740 bduvarag*/
3831: CURSOR c_sh_cess_amount IS
3832: SELECT sum(a.tax_amount)
3833: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3834: WHERE delivery_detail_id = p_reference_line_id
3835: AND a.tax_id = b.tax_id
3836: AND upper(b.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);
3837:

Line 4373: JAI_CMN_TAXES_ALL jtc

4369: */
4370: cursor c_get_om_cess_amount(cp_delivery_id number) is
4371: 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
4372: from JAI_OM_WSH_LINE_TAXES jsptl ,
4373: JAI_CMN_TAXES_ALL jtc
4374: where jtc.tax_id = jsptl.tax_id
4375: and delivery_detail_id in
4376: (select delivery_detail_id
4377: from JAI_OM_WSH_LINES_ALL

Line 4385: JAI_CMN_TAXES_ALL jtc

4381: /*Bug 5989740 bduvarag*/
4382: cursor c_get_om_sh_cess_amount(cp_delivery_id number) is
4383: select NVL(sum(jsptl.func_tax_amount),0) tax_amount
4384: from JAI_OM_WSH_LINE_TAXES jsptl ,
4385: JAI_CMN_TAXES_ALL jtc
4386: where jtc.tax_id = jsptl.tax_id
4387: and delivery_detail_id in
4388: (select delivery_detail_id
4389: from JAI_OM_WSH_LINES_ALL

Line 4398: JAI_CMN_TAXES_ALL jtc

4394:
4395: cursor c_get_ar_cess_amount(cp_customer_trx_id number) is
4396: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4397: from JAI_AR_TRX_TAX_LINES jrctl ,
4398: JAI_CMN_TAXES_ALL jtc
4399: where jtc.tax_id = jrctl.tax_id
4400: and link_to_cust_trx_line_id in
4401: (select customer_trx_line_id
4402: from JAI_AR_TRX_LINES

Line 4410: JAI_CMN_TAXES_ALL jtc

4406: /*Bug 5989740 bduvarag*/
4407: cursor c_get_ar_sh_cess_amount(cp_customer_trx_id number) is
4408: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4409: from JAI_AR_TRX_TAX_LINES jrctl ,
4410: JAI_CMN_TAXES_ALL jtc
4411: where jtc.tax_id = jrctl.tax_id
4412: and link_to_cust_trx_line_id in
4413: (select customer_trx_line_id
4414: from JAI_AR_TRX_LINES

Line 4422: JAI_CMN_TAXES_ALL jtc

4418:
4419: cursor c_ar_cess_ctr(cp_customer_trx_id number) is
4420: select count(1)
4421: from JAI_AR_TRX_TAX_LINES jrctl ,
4422: JAI_CMN_TAXES_ALL jtc
4423: where jtc.tax_id = jrctl.tax_id
4424: and link_to_cust_trx_line_id in
4425: (select customer_trx_line_id
4426: from JAI_AR_TRX_LINES

Line 4434: JAI_CMN_TAXES_ALL jtc

4430: /*Bug 5989740 bduvarag*/
4431: cursor c_ar_sh_cess_ctr(cp_customer_trx_id number) is
4432: select count(1)
4433: from JAI_AR_TRX_TAX_LINES jrctl ,
4434: JAI_CMN_TAXES_ALL jtc
4435: where jtc.tax_id = jrctl.tax_id
4436: and link_to_cust_trx_line_id in
4437: (select customer_trx_line_id
4438: from JAI_AR_TRX_LINES

Line 4575: JAI_CMN_TAXES_ALL jtc

4571: jrctl.precedence_8,
4572: jrctl.precedence_9,
4573: jrctl.precedence_10
4574: from JAI_AR_TRX_TAX_LINES jrctl ,
4575: JAI_CMN_TAXES_ALL jtc
4576: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4577: and jtc.tax_id = jrctl.tax_id
4578: and jtc.tax_type in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS)
4579: )

Line 4640: JAI_CMN_TAXES_ALL jtc

4636: jrctl.precedence_8,
4637: jrctl.precedence_9,
4638: jrctl.precedence_10
4639: from JAI_AR_TRX_TAX_LINES jrctl ,
4640: JAI_CMN_TAXES_ALL jtc
4641: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4642: and jtc.tax_id = jrctl.tax_id
4643: and jtc.tax_type in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess)
4644: )