APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 806: ra_cust_trx_types_all trx_types ,

802: nvl(jtc.reverse_charge_flag,'N') reverse_charge_flag --Added by Qiong for reverse charge bug#16001407
803: FROM
804: ra_customer_trx_all trx ,
805: JAI_AR_TRXS jtrx ,
806: ra_cust_trx_types_all trx_types ,
807: JAI_AR_TRX_LINES jtrxl ,
808: JAI_AR_TRX_TAX_LINES jtrxtl ,
809: ra_customer_trx_lines_all rctla , /*14121914*/
810: JAI_CMN_TAXES_ALL jtc ,

Line 1233: ra_cust_trx_types_all trx_types

1229: NOT EXISTS ( SELECT
1230: 1
1231: FROM
1232: ra_customer_trx_all trx ,
1233: ra_cust_trx_types_all trx_types
1234: WHERE
1235: trx.customer_trx_id = rgtr.invoice_id AND
1236: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND
1237: trx_types.org_id = trx.org_id AND

Line 1714: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980

1710: ln_uncommitted_transactions NUMBER(10) := 0 ;
1711: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1712: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1713: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1714: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1715: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1716: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980
1717: lv_attribute_context jai_rgm_trx_records.attribute_context%TYPE ;--rchandan for bug#4428980
1718:

Line 1767: ra_cust_trx_types_all trx_types ,

1763: FROM
1764: ar_receivable_applications_all aral ,
1765: ra_customer_trx_all cm_trx ,
1766: ra_customer_trx_all inv_trx ,
1767: ra_cust_trx_types_all trx_types ,
1768: JAI_AR_TRXS inv_jtrx ,
1769: JAI_AR_TRXS cm_jtrx
1770: WHERE
1771: aral.customer_trx_id = cm_trx.customer_trx_id AND

Line 2631: ra_cust_trx_types_all trx_types ,

2627: FROM
2628: ar_receivable_applications_all aral ,
2629: ar_cash_receipts_all acrl ,
2630: ra_customer_trx_all trx ,
2631: ra_cust_trx_types_all trx_types ,
2632: JAI_AR_TRXS jtrx
2633: WHERE
2634: aral.cash_receipt_id = acrl.cash_receipt_id AND
2635: aral.applied_customer_trx_id = trx.customer_trx_id AND

Line 3408: ra_cust_trx_types_all trx_types ,

3404: trx.trx_date
3405:
3406: FROM
3407: ra_customer_trx_all trx ,
3408: ra_cust_trx_types_all trx_types ,
3409: JAI_AR_TRXS jtrx
3410: WHERE
3411: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND
3412: jtrx.organization_id = p_organization_id AND

Line 3449: , ra_cust_trx_types_all trx_types

3445: , jtrx.st_inv_number --Added by Qiong for Advanced Receipts
3446: FROM jai_ar_trx_tax_lines jattl
3447: , ra_customer_trx_lines_all trxl
3448: , ra_customer_trx_all trx
3449: , ra_cust_trx_types_all trx_types
3450: , jai_ar_trxs jtrx
3451: , ra_cust_trx_line_gl_dist_all gd --Added by Qiong for bug13540741
3452: WHERE jattl.link_to_cust_trx_line_id = trxl.customer_trx_line_id
3453: AND trxl.customer_trx_id = trx.customer_trx_id

Line 5139: ra_cust_trx_types_all rctt

5135: rctt.gl_id_rec ,
5136: rctt.creation_sign
5137: FROM
5138: ra_batch_sources_all bsa ,
5139: ra_cust_trx_types_all rctt
5140: WHERE
5141: bsa.default_inv_trx_type = rctt.cust_trx_type_id
5142: AND bsa.org_id = rctt.org_id
5143: AND bsa.org_id = cp_org_id

Line 5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;

5185: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5186: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5187: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;
5190: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5191: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5192: lv_trx_number_prefix RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5193: ln_ccid_tax_type NUMBER;