[Home] [Help]
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,
2246: ar_distributions_all ard
2247: WHERE gt.event_type_code = 'ADJ_CREATE'
2248: AND gt.application_id = p_application_id
2249: AND adj.adjustment_id = gt.source_id_int_1
7618: --BUG#4645389
7619: ,tl.tax_line_id --tax_line_id
7620: ,'N'
7621: FROM xla_events_gt gt,
7622: ar_transaction_history_all th,
7623: ra_customer_trx_all trx,
7624: ra_customer_trx_lines_all tl,
7625: ra_cust_trx_line_gl_dist_all gld,
7626: oe_system_parameters_all osp,
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
8013: -- AR_MC_TRANSACTION_HISTORY E (Bill Receivables)
8014: -- Question are there any side effect
8015: -- from BR on TRX ?
8016: ------------------
8183:
8184: --
8185: -- TH
8186: -- GL Posting entiting are
8187: -- AR_TRANSACTION_HISTORY_ALL,
8188: --
8189: UPDATE AR_TRANSACTION_HISTORY_ALL
8190: SET posting_control_id = l_pst_id,
8191: gl_posted_date = l_date,
8185: -- TH
8186: -- GL Posting entiting are
8187: -- AR_TRANSACTION_HISTORY_ALL,
8188: --
8189: UPDATE AR_TRANSACTION_HISTORY_ALL
8190: SET posting_control_id = l_pst_id,
8191: gl_posted_date = l_date,
8192: last_updated_by = fnd_global.user_id,
8193: last_update_date = sysdate,
8374: --TRH
8375: SELECT 'lock'
8376: BULK COLLECT INTO l_lock
8377: FROM xla_entity_events_v eve,
8378: ar_transaction_history_all trh
8379: WHERE eve.request_id = p_report_request_id
8380: AND eve.application_id = p_application_id
8381: AND eve.entity_code = 'BILLS_RECEIVABLE'
8382: AND eve.event_id = trh.event_id