APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_AR_TRXS

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

1029: ST Form request has performance problem. The Request takes exceptionally long time when
1030: customer Name is not given in parameter
1031: Fix:-
1032: Cursor c_fetch_records in generate_ar_forms procedure has high cost. Query doesn't have
1033: a Localization table jai_ar_trxs. After adding a table jai_ar_trxs, cost is reduced,
1034: thus improving the performance
1035:
1036:
1037: ---------------------------------------------------------------------------------------------------------------- */

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

1648: 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,
1649: decode( trx_types.TYPE ,'INV','Invoice','CM','Credit Memo','DM','Debit Memo',trx_types.TYPE ) document_type /*JMEENA for bug#4932256( FP 4913641)*/
1650: from ra_customer_Trx_all trx ,
1651: ra_cust_trx_types_all trx_types ,
1652: jai_ar_trxs jtrx /* Added for bug#5376622 */
1653: where
1654: trx.customer_trx_id = jtrx.customer_trx_id AND
1655: (trx.bill_to_customer_id = nvl(p_party_id,trx.bill_to_customer_id)
1656: OR

Line 1727: from JAI_AR_TRXS

1723:
1724: cursor c_orgn_locn (p_invoice_id number)
1725: is
1726: select organization_id , location_id
1727: from JAI_AR_TRXS
1728: where customer_trx_id = p_invoice_id;
1729:
1730: cursor c_trx_type(p_cust_trx_type_id number) is
1731: select type