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_OM_WSH_LINE_TAXES

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 699: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

695: This was done because if there is no cess amount, there is no need to call the insert row procedure
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

Line 727: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

723:
724: -- foll cursor added by ssumaith - bug# 5747126 - one off
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

Line 976: Based on the delivery detail id , pick up the delivery id, organization id and get the taxes from JAI_OM_WSH_LINE_TAXES

972: p_source_name := 'Register India' ;
973: p_category_name := 'Register India' ;
974: p_transaction_hdr_id := It has the delivery detail id
975:
976: Based on the delivery detail id , pick up the delivery id, organization id and get the taxes from JAI_OM_WSH_LINE_TAXES
977:
978: If called from AR invoice completion the values for the parameters are as follows.
979:
980: p_source_name := 'Receivables India'

Line 1013: Do all things needed to populate records into the register table , picking up taxes from the JAI_OM_WSH_LINE_TAXES table

1009: end if;
1010:
1011: if p_je_source_name = 'Register India' and p_je_category_name = 'Register India' then
1012: /*
1013: Do all things needed to populate records into the register table , picking up taxes from the JAI_OM_WSH_LINE_TAXES table
1014: */
1015: ln_header_id := ln_delivery_id;
1016: ja_in_om_cess_register_entries(p_delivery_id => ln_delivery_id ,
1017: p_source_type => p_source_type ,

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 4372: from JAI_OM_WSH_LINE_TAXES jsptl ,

4368: following two cursors added by ssumaith - bug# 4136981
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

Line 4384: from JAI_OM_WSH_LINE_TAXES jsptl ,

4380: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
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