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_AR_SUP_TRX_PKG dependencies on JAI_AR_TRXS

Line 39: Modified the cursor get_invoices. Added the IL table jai_ar_trxs to the ra_customer_trx_all

35: Performance tuning for the cursor get_invoices SQL_ID 14827611. Cost = 1287 and sharabale memory 182519
36:
37:
38: Fix :-
39: Modified the cursor get_invoices. Added the IL table jai_ar_trxs to the ra_customer_trx_all
40: and also merged the correlated query to the main query thus reducing the sharable memory also
41:
42:
43: 01/11/2006 SACSETHI for bug 5228046, File version 120.10

Line 134: || Added the IL table jai_ar_trxs to the ra_customer_trx_all and

130: -- TILL HERE
131:
132: /*
133: || Cursor modified by aiyer for the bug 4947681.SQL ID 14827611
134: || Added the IL table jai_ar_trxs to the ra_customer_trx_all and
135: || also merged the correlated query to the main query thus reducing the sharable memory also
136: || New Cost = 28 Sharable memory = 113499
137: */
138: CURSOR GET_INVOICE ( effective_from_date DATE ,

Line 156: jai_ar_trxs jat ,

152: rcta.interface_header_attribute6,
153: rcta.interface_header_attribute7,
154: rcta.invoice_currency_code
155: FROM ra_customer_trx_all rcta,
156: jai_ar_trxs jat ,
157: ra_cust_trx_types_all rctta
158: WHERE
159: rcta.customer_trx_id = jat.customer_trx_id
160: AND rcta.cust_trx_type_id = rctta.cust_trx_type_id

Line 654: jai_ar_trxs jat /* added the table and join condition - aiyer for the fwd porting bug 5225768*/

650: FROM ra_customer_trx_all a,
651: ra_customer_trx_lines_all b,
652: mtl_system_items c,
653: jai_ar_trx_sup_inv_t d, -- added by sriram - bug # 3143813 - 19/09/2003
654: jai_ar_trxs jat /* added the table and join condition - aiyer for the fwd porting bug 5225768*/
655: WHERE a.customer_trx_id = b.customer_trx_id
656: AND b.inventory_item_id = c.inventory_item_id
657: --AND c.organization_id = b.warehouse_id
658: AND ( b.interface_line_attribute11 IS NULL

Line 1999: JAI_AR_TRXS C

1995: B.term_id,
1996: C.organization_id
1997: FROM JAI_AR_SUP_HDRS_ALL A,
1998: RA_CUSTOMER_TRX_ALL B,
1999: JAI_AR_TRXS C
2000: where A.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
2001: AND A.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
2002: AND A.chosen_for_process = 'Y'
2003: AND A.SUPPLEMENTARY_NUM IS NULL;

Line 2036: JAI_AR_TRXS c

2032: c.organization_id, --2001/05/10 Anuradha Parthasarathy,
2033: a.interface_line_attribute2
2034: from JAI_AR_SUP_HDRS_ALL b,
2035: JAI_AR_SUP_LINES a,
2036: JAI_AR_TRXS c
2037: where a.customer_trx_id = b.customer_trx_id
2038: and a.customer_trx_id = c.customer_trx_id
2039: and a.sup_inv_type = b.supp_inv_type
2040: and b.chosen_for_process = 'Y'