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_DOCUMENT_TAXES

Line 107: + Tax Amount and Line Amount are populated from jai_cmn_document_taxes (Tax Amount column)

103: 21. 31-Jan-2011 Bug 10434986
104: Description:
105: + JAI_TRX_REPO_EXTRACT_GT is populated with incorrect Document Line ID
106: (Line Number of Tax Line is inserted into document line id column instead of Item Line Number)
107: + Tax Amount and Line Amount are populated from jai_cmn_document_taxes (Tax Amount column)
108: Hence if partial payment is made, the same is not considered and the whole tax amount
109: is shown in the Service Tax Repository Review window
110: Fix:
111: + Inserted Line Number of Item into Document Line ID

Line 1739: cursor c_get_pa_inv_line_tax (cp_line_id jai_cmn_document_taxes.source_doc_line_id%type )

1735: --and jtc.tax_type = 'Service'
1736: group by service_type_code;
1737:
1738: -- Bug 5876390, 6012570
1739: cursor c_get_pa_inv_line_tax (cp_line_id jai_cmn_document_taxes.source_doc_line_id%type )
1740: is
1741: select sum(tax_amt) service_tax_amount
1742: from jai_cmn_document_taxes jcdt
1743: , jai_cmn_taxes_all jtc

Line 1742: from jai_cmn_document_taxes jcdt

1738: -- Bug 5876390, 6012570
1739: cursor c_get_pa_inv_line_tax (cp_line_id jai_cmn_document_taxes.source_doc_line_id%type )
1740: is
1741: select sum(tax_amt) service_tax_amount
1742: from jai_cmn_document_taxes jcdt
1743: , jai_cmn_taxes_all jtc
1744: where jcdt.source_doc_line_id = cp_line_id
1745: and jcdt.source_doc_type = jai_constants.PA_DRAFT_INVOICE
1746: and jcdt.tax_id = jtc.tax_id

Line 1833: CURSOR c_get_standalone_inv_line_tax (cp_invoice_id jai_cmn_document_taxes.source_doc_id%type, cp_line_id jai_cmn_document_taxes.source_doc_line_id%type) IS

1829: --------------------------------------------------------------------
1830: --Add by Xiao for fixing bug#10634960, end
1831: and PARENT_INVOICE_LINE_NUMBER is NULL;
1832:
1833: CURSOR c_get_standalone_inv_line_tax (cp_invoice_id jai_cmn_document_taxes.source_doc_id%type, cp_line_id jai_cmn_document_taxes.source_doc_line_id%type) IS
1834: Select service_type_code,sum(jcdt.tax_amt)
1835: from jai_ap_invoice_lines jasl,
1836: jai_cmn_document_taxes jcdt,
1837: jai_cmn_taxes_all jcta

Line 1836: jai_cmn_document_taxes jcdt,

1832:
1833: CURSOR c_get_standalone_inv_line_tax (cp_invoice_id jai_cmn_document_taxes.source_doc_id%type, cp_line_id jai_cmn_document_taxes.source_doc_line_id%type) IS
1834: Select service_type_code,sum(jcdt.tax_amt)
1835: from jai_ap_invoice_lines jasl,
1836: jai_cmn_document_taxes jcdt,
1837: jai_cmn_taxes_all jcta
1838: where source_doc_line_id = cp_line_id
1839: AND jcdt.source_doc_id = cp_invoice_id
1840: AND jasl.invoice_id = jcdt.source_doc_id