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

Line 960: ,jai_cmn_taxes_all jtc

956: is
957: select service_type_code, sum(jrcttl.tax_amount) service_tax_amount
958: from JAI_AR_TRX_LINES jrctl
959: ,JAI_AR_TRX_TAX_LINES jrcttl
960: ,jai_cmn_taxes_all jtc
961: where jrctl.customer_trx_line_id = cp_customer_trx_line_id
962: and jrcttl.link_to_cust_trx_line_id = jrctl.customer_trx_line_id
963: and jtc.tax_id = jrcttl.tax_id
964: /*added the cess and sh cess tax types for bug#6457710*/

Line 973: , jai_cmn_taxes_all jtc

969: cursor c_get_so_line_srvtyp (cp_line_id JAI_OM_OE_SO_LINES.line_id%type ) is
970: select service_type_code, sum(jstl.tax_amount) service_tax_amount
971: from JAI_OM_OE_SO_LINES jsl
972: , JAI_OM_OE_SO_TAXES jstl
973: , jai_cmn_taxes_all jtc
974: where jsl.line_id = cp_line_id
975: and jsl.line_id = jstl.line_id
976: and jstl.tax_id = jtc.tax_id
977: /*added the cess and sh cess tax types for bug#6457710*/

Line 989: , JAI_CMN_TAXES_ALL jtc

985: is
986: select service_type_code, sum(jrtl.tax_amount) service_tax_amount
987: from JAI_OM_OE_RMA_LINES jrl
988: , JAI_OM_OE_RMA_TAXES jrtl
989: , JAI_CMN_TAXES_ALL jtc
990: where jrl.rma_line_id = cp_line_id
991: and jrl.rma_line_id = jrtl.rma_line_id
992: and jrtl.tax_id = jtc.tax_id
993: /*added the cess and sh cess tax types for bug#6457710*/

Line 1003: , jai_cmn_taxes_all jtc

999: cursor c_get_pa_inv_line_tax (cp_line_id jai_cmn_document_taxes.source_doc_line_id%type )
1000: is
1001: select sum(tax_amt) service_tax_amount
1002: from jai_cmn_document_taxes jcdt
1003: , jai_cmn_taxes_all jtc
1004: where jcdt.source_doc_line_id = cp_line_id
1005: and jcdt.source_doc_type = jai_constants.PA_DRAFT_INVOICE
1006: and jcdt.tax_id = jtc.tax_id
1007: /*added the cess and sh cess tax types for bug#6457710*/

Line 1024: , jai_cmn_taxes_all jcta

1020: , SUM (jcdt.tax_amt)
1021: FROM
1022: jai_ap_invoice_lines jasl
1023: , jai_cmn_document_taxes jcdt
1024: , jai_cmn_taxes_all jcta
1025: WHERE jasl.invoice_id = jcdt.source_doc_id
1026: AND jasl.invoice_line_number = jcdt.source_doc_line_id
1027: AND jcdt.source_doc_line_id = lp_line_id
1028: AND jcdt.source_doc_id = p_document_id

Line 1045: , jai_cmn_taxes_all jcta

1041: SUM (jcdt.tax_amt)
1042: FROM
1043: jai_ap_invoice_lines jasl
1044: , jai_cmn_document_taxes jcdt
1045: , jai_cmn_taxes_all jcta
1046: WHERE jasl.invoice_id = p_document_id
1047: AND jasl.parent_invoice_line_number = lp_line_id
1048: AND jasl.invoice_id = jcdt.source_doc_id
1049: AND jasl.invoice_line_number = jcdt.source_doc_line_id