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_AR_TRX_TAX_LINES

Line 869: FROM JAI_AR_TRX_TAX_LINES jrctl ,

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

Line 984: Based on the customer_trx_line_id , pick up the customer_trx_id , organization id and get the taxes from JAI_AR_TRX_TAX_LINES

980: p_source_name := 'Receivables India'
981: p_category_name := 'RG Register Data Entry'
982: p_transaction_hdr_id := customer_trx_line_id from JAI_AR_TRX_LINES table
983:
984: Based on the customer_trx_line_id , pick up the customer_trx_id , organization id and get the taxes from JAI_AR_TRX_TAX_LINES
985:
986: */
987: if p_source_type = 2 then
988: ln_customer_trx_id := p_transaction_hdr_id;

Line 2680: , jai_ar_trx_tax_lines jattl

2676: CURSOR get_external_tax_cur IS
2677: SELECT tax.code_combination_id
2678: , tax.tax_amount
2679: FROM jai_ar_trx_lines jatl
2680: , jai_ar_trx_tax_lines jattl
2681: , jai_interface_lines_all lines
2682: , jai_interface_tax_lines_all tax
2683: WHERE jatl.customer_trx_line_id = p_picking_line_id
2684: AND jattl.customer_trx_line_id = p_picking_line_id

Line 3184: , jai_ar_trx_tax_lines jattl

3180: CURSOR get_external_tax_cur IS
3181: SELECT tax.code_combination_id
3182: , tax.tax_amount
3183: FROM jai_ar_trx_lines jatl
3184: , jai_ar_trx_tax_lines jattl
3185: , jai_interface_lines_all lines
3186: , jai_interface_tax_lines_all tax
3187: WHERE jatl.customer_trx_line_id = p_header_id
3188: AND jattl.customer_trx_line_id = p_header_id

Line 4397: from JAI_AR_TRX_TAX_LINES jrctl ,

4393:
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

Line 4409: from JAI_AR_TRX_TAX_LINES jrctl ,

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

Line 4421: from JAI_AR_TRX_TAX_LINES jrctl ,

4417: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
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

Line 4433: from JAI_AR_TRX_TAX_LINES jrctl ,

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

Line 4574: from JAI_AR_TRX_TAX_LINES jrctl ,

4570: jrctl.precedence_7,
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)

Line 4588: from JAI_AR_TRX_TAX_LINES

4584: decode(tax_amount, 0,
4585: (base_tax_amount * ( tax_rate / 100) )
4586: , tax_amount
4587: ) cess_amt
4588: from JAI_AR_TRX_TAX_LINES
4589: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4590: and tax_line_no in
4591: (cess_rec.precedence_1,
4592: cess_rec.precedence_2,

Line 4639: from JAI_AR_TRX_TAX_LINES jrctl ,

4635: jrctl.precedence_7,
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)

Line 4653: from JAI_AR_TRX_TAX_LINES

4649: decode(tax_amount, 0,
4650: (base_tax_amount * ( tax_rate / 100) )
4651: , tax_amount
4652: ) sh_cess_amt
4653: from JAI_AR_TRX_TAX_LINES
4654: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4655: and tax_line_no in
4656: (cess_rec.precedence_1,
4657: cess_rec.precedence_2,