[Home] [Help]
8310:
8311: -- CTLGD
8312: SELECT 'lock'
8313: BULK COLLECT INTO l_lock
8314: FROM xla_entity_events_v eve,
8315: ra_cust_trx_line_gl_dist_all ctlgd
8316: WHERE eve.request_id = p_report_request_id
8317: AND eve.application_id = p_application_id
8318: AND eve.entity_code = 'TRANSACTIONS'
8323:
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'
8336:
8337: -- APP
8338: SELECT 'lock'
8339: BULK COLLECT INTO l_lock
8340: FROM xla_entity_events_v eve,
8341: ar_receivable_applications_all app
8342: WHERE eve.request_id = p_report_request_id
8343: AND eve.application_id = p_application_id
8344: AND eve.entity_code IN ('RECEIPTS','TRANSACTIONS')
8350:
8351: -- CRH MCD
8352: SELECT 'lock'
8353: BULK COLLECT INTO l_lock
8354: FROM xla_entity_events_v eve,
8355: ar_cash_receipt_history_all crh
8356: WHERE eve.request_id = p_report_request_id
8357: AND eve.application_id = p_application_id
8358: AND eve.entity_code = 'RECEIPTS'
8361: FOR UPDATE OF crh.cash_receipt_history_id;
8362:
8363: SELECT 'lock'
8364: BULK COLLECT INTO l_lock
8365: FROM xla_entity_events_v eve,
8366: ar_misc_cash_distributions_all mcd
8367: WHERE eve.request_id = p_report_request_id
8368: AND eve.application_id = p_application_id
8369: AND eve.entity_code = 'RECEIPTS'
8373:
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'