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.

[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_AR_TRX_LINES

Line 1821: FROM JAI_AR_TRX_LINES trx_lines

1817: a.trx_number = trx.trx_number /*Bug 10196549 - Clause required to distinguish transactions with same customer_trx_id and delivery_id*/
1818: ) AND
1819: EXISTS
1820: (SELECT 1
1821: FROM JAI_AR_TRX_LINES trx_lines
1822: WHERE customer_trx_id = trx.customer_trx_id AND
1823: EXISTS
1824: (SELECT 1
1825: FROM JAI_AR_TRX_TAX_LINES tax_lines ,

Line 1864: from JAI_AR_TRX_LINES

1860: JAI_CMN_TAXES_ALL jtc
1861: where link_to_cust_Trx_line_id in
1862: (
1863: select customer_Trx_line_id
1864: from JAI_AR_TRX_LINES
1865: where customer_trx_id = p_invoice_id
1866: )
1867: and jtc.tax_id = jtxn.tax_id
1868: and jtc.tax_type in ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 1961: from JAI_AR_TRX_LINES

1957: and tax_id = p_tax_id;
1958:
1959: cursor c_get_line_amount
1960: is select line_amount
1961: from JAI_AR_TRX_LINES
1962: where customer_trx_line_id = p_link_to_line_id;
1963:
1964: v_prec_rec c_get_precedences%rowtype;
1965: