DBA Data[Home] [Help]

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 122: || Added the IL table jai_ar_trxs to the ra_customer_trx_all and

118: -- TILL HERE
119:
120: /*
121: || Cursor modified by aiyer for the bug 4947681.SQL ID 14827611
122: || Added the IL table jai_ar_trxs to the ra_customer_trx_all and
123: || also merged the correlated query to the main query thus reducing the sharable memory also
124: || New Cost = 28 Sharable memory = 113499
125: */
126: CURSOR GET_INVOICE ( effective_from_date DATE ,

Line 144: jai_ar_trxs jat ,

140: rcta.interface_header_attribute6,
141: rcta.interface_header_attribute7,
142: rcta.invoice_currency_code
143: FROM ra_customer_trx_all rcta,
144: jai_ar_trxs jat ,
145: ra_cust_trx_types_all rctta
146: WHERE
147: rcta.customer_trx_id = jat.customer_trx_id
148: AND rcta.cust_trx_type_id = rctta.cust_trx_type_id

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

579: FROM ra_customer_trx_all a,
580: ra_customer_trx_lines_all b,
581: mtl_system_items c,
582: jai_ar_trx_sup_inv_t d, -- added by sriram - bug # 3143813 - 19/09/2003
583: jai_ar_trxs jat /* added the table and join condition - aiyer for the fwd porting bug 5225768*/
584: WHERE a.customer_trx_id = b.customer_trx_id
585: AND b.inventory_item_id = c.inventory_item_id
586: --AND c.organization_id = b.warehouse_id
587: AND ( b.interface_line_attribute11 IS NULL

Line 1871: JAI_AR_TRXS C

1867: B.term_id,
1868: C.organization_id
1869: FROM JAI_AR_SUP_HDRS_ALL A,
1870: RA_CUSTOMER_TRX_ALL B,
1871: JAI_AR_TRXS C
1872: where A.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
1873: AND A.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
1874: AND A.chosen_for_process = 'Y'
1875: AND A.SUPPLEMENTARY_NUM IS NULL;

Line 1908: JAI_AR_TRXS c

1904: c.organization_id, --2001/05/10 Anuradha Parthasarathy,
1905: a.interface_line_attribute2
1906: from JAI_AR_SUP_HDRS_ALL b,
1907: JAI_AR_SUP_LINES a,
1908: JAI_AR_TRXS c
1909: where a.customer_trx_id = b.customer_trx_id
1910: and a.customer_trx_id = c.customer_trx_id
1911: and a.sup_inv_type = b.supp_inv_type
1912: and b.chosen_for_process = 'Y'