APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_AR_TRXS

Line 1173: a Localization table jai_ar_trxs. After adding a table jai_ar_trxs, cost is reduced,

1169: ST Form request has performance problem. The Request takes exceptionally long time when
1170: customer Name is not given in parameter
1171: Fix:-
1172: Cursor c_fetch_records in generate_ar_forms procedure has high cost. Query doesn't have
1173: a Localization table jai_ar_trxs. After adding a table jai_ar_trxs, cost is reduced,
1174: thus improving the performance
1175:
1176:
1177: ---------------------------------------------------------------------------------------------------------------- */

Line 1798: jai_ar_trxs jtrx /* Added for bug#5376622 */

1794: nvl(trx.bill_to_customer_id,trx.ship_to_customer_id) customer_id, nvl(trx.bill_to_site_use_id,trx.ship_to_site_use_id) customer_site_id,
1795: decode( trx_types.TYPE ,'INV','Invoice','CM','Credit Memo','DM','Debit Memo',trx_types.TYPE ) document_type /*JMEENA for bug#4932256( FP 4913641)*/
1796: from ra_customer_Trx_all trx ,
1797: ra_cust_trx_types_all trx_types ,
1798: jai_ar_trxs jtrx /* Added for bug#5376622 */
1799: where
1800: trx.customer_trx_id = jtrx.customer_trx_id AND
1801: (trx.bill_to_customer_id = nvl(p_party_id,trx.bill_to_customer_id)
1802: OR

Line 1874: from JAI_AR_TRXS

1870:
1871: cursor c_orgn_locn (p_invoice_id number)
1872: is
1873: select organization_id , location_id
1874: from JAI_AR_TRXS
1875: where customer_trx_id = p_invoice_id;
1876:
1877: cursor c_trx_type(p_cust_trx_type_id number) is
1878: select type