[Home] [Help]
497: jtrxtl.link_to_cust_trx_line_id
498: FROM
499: ra_customer_trx_all trx ,
500: JAI_AR_TRXS jtrx ,
501: ra_cust_trx_types_all trx_types ,
502: JAI_AR_TRX_LINES jtrxl ,
503: JAI_AR_TRX_TAX_LINES jtrxtl ,
504: JAI_CMN_TAXES_ALL jtc
505: WHERE
704: NOT EXISTS ( SELECT
705: 1
706: FROM
707: ra_customer_trx_all trx ,
708: ra_cust_trx_types_all trx_types
709: WHERE
710: trx.customer_trx_id = rgtr.invoice_id AND
711: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND
712: trx_types.org_id = trx.org_id AND
1155: ln_uncommitted_transactions NUMBER(10) := 0 ;
1156: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1157: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1158: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1159: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1160: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1161: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980
1162: lv_attribute_context jai_rgm_trx_records.attribute_context%TYPE ;--rchandan for bug#4428980
1163:
1195: FROM
1196: ar_receivable_applications_all aral ,
1197: ra_customer_trx_all cm_trx ,
1198: ra_customer_trx_all inv_trx ,
1199: ra_cust_trx_types_all trx_types ,
1200: JAI_AR_TRXS inv_jtrx ,
1201: JAI_AR_TRXS cm_jtrx
1202: WHERE
1203: aral.customer_trx_id = cm_trx.customer_trx_id AND
1906: FROM
1907: ar_receivable_applications_all aral ,
1908: ar_cash_receipts_all acrl ,
1909: ra_customer_trx_all trx ,
1910: ra_cust_trx_types_all trx_types ,
1911: JAI_AR_TRXS jtrx
1912: WHERE
1913: aral.cash_receipt_id = acrl.cash_receipt_id AND
1914: aral.applied_customer_trx_id = trx.customer_trx_id AND