APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_ADJUSTMENTS_ALL

Line 2156: FROM ar_adjustments_all adj,

2152: ,gt.event_type_code
2153: ,gt.event_class_code
2154: ,gt.entity_code
2155: ,'N' --MFAR_ADDITIONAL_ENTRY
2156: FROM ar_adjustments_all adj,
2157: gl_sets_of_books sob,
2158: xla_events_gt gt,
2159: ra_customer_trx_all trxf,
2160: ra_cust_trx_line_gl_dist_all ctlgd

Line 2241: FROM ar_adjustments_all adj,

2237: ,gt.event_type_code
2238: ,gt.event_class_code
2239: ,gt.entity_code
2240: ,'N' --MFAR_ADDITIONAL_ENTRY
2241: FROM ar_adjustments_all adj,
2242: gl_sets_of_books sob,
2243: xla_events_gt gt,
2244: ra_customer_trx_all trxf,
2245: ar_transaction_history_all trh,

Line 3067: ar_adjustments_all adj,

3063: ,decode(trxt.upgrade_method,'R12_11ICASH','N','')
3064: --}
3065: FROM xla_events_gt gt,
3066: ar_distributions_all dist,
3067: ar_adjustments_all adj,
3068: gl_sets_of_books sob,
3069: ra_customer_trx_all trxt,
3070: ra_customer_trx_lines_all tlt,
3071: ra_cust_trx_line_gl_dist_all gldt,

Line 8008: -- AR_ADJUSTMENTS_ALL C Those 2 C entities will post together

8004: -- AR_MISC_CASH_DISTRIBUTIONS_ALL A
8005: -- AR_MC_MISC_CASH_DISTS A
8006: -- RA_CUST_TRX_LINE_GL_DIST_ALL B Those 2 B entities will post tpgether
8007: -- RA_MC_TRX_LINE_GL_DIST B (Transactions)
8008: -- AR_ADJUSTMENTS_ALL C Those 2 C entities will post together
8009: -- AR_MC_ADJUSTMENTS C (Adjustments)
8010: -- AR_RECEIVABLE_APPLICATIONS_ALL D Those 2 D entities will post together
8011: -- AR_MC_RECEIVABLE_APPS D (Applications)
8012: -- AR_TRANSACTION_HISTORY_ALL E Those 2 E entities will post together

Line 8145: -- AR_ADJUSTMENTS_ALL,

8141:
8142: --
8143: -- ADJ
8144: -- GL Posting entiting are
8145: -- AR_ADJUSTMENTS_ALL,
8146: --
8147: UPDATE ar_adjustments_all
8148: SET posting_control_id = l_pst_id,
8149: gl_posted_date = l_date,

Line 8147: UPDATE ar_adjustments_all

8143: -- ADJ
8144: -- GL Posting entiting are
8145: -- AR_ADJUSTMENTS_ALL,
8146: --
8147: UPDATE ar_adjustments_all
8148: SET posting_control_id = l_pst_id,
8149: gl_posted_date = l_date,
8150: last_updated_by = fnd_global.user_id,
8151: last_update_date = sysdate,

Line 8328: ar_adjustments_all adj

8324: -- ADJ
8325: SELECT 'lock'
8326: BULK COLLECT INTO l_lock
8327: FROM xla_entity_events_v eve,
8328: ar_adjustments_all adj
8329: WHERE eve.request_id = p_report_request_id
8330: AND eve.application_id = p_application_id
8331: AND eve.entity_code = 'ADJUSTMENTS'
8332: AND eve.event_id = adj.event_id