[Home] [Help]
207: hdr.doc_sequence_value doc_seq_value,
208: hdr.doc_category_code cat_code,
209: ctlgd.set_of_books_id sob_id
210: --
211: from ra_mc_customer_trx ct,
212: ra_customer_trx_all trx,
213: ra_cust_trx_line_gl_dist_all gld,
214: xla_upgrade_dates gps,
215: ra_mc_trx_line_gl_dist ctlgd,
272: hdr.doc_sequence_value doc_seq_value,
273: hdr.doc_category_code cat_code,
274: dist.set_of_books_id sob_id
275: --
276: from ra_mc_customer_trx ct,
277: ra_customer_trx_all trx,
278: ar_receivable_applications_all ra,
279: xla_upgrade_dates gps,
280: ar_mc_receivable_apps app,
341: hdr.doc_sequence_value doc_seq_value,
342: hdr.doc_category_code cat_code,
343: dist.set_of_books_id sob_id
344: --
345: from ra_mc_customer_trx ct,
346: ra_customer_trx_all trx,
347: ar_transaction_history_all th,
348: xla_upgrade_dates gps,
349: ar_mc_transaction_history trh,
639: hdr.accounting_date accounting_date,
640: hdr1.ledger_id ledger_id,
641: 1 ln_order
642: --
643: from ra_mc_customer_trx ct,
644: ra_customer_trx_all trx,
645: ra_cust_trx_line_gl_dist_all gld,
646: xla_upgrade_dates gps,
647: ra_mc_trx_line_gl_dist ctlgd,
724: hdr.accounting_date accounting_date,
725: hdr1.ledger_id ledger_id,
726: 2 ln_order
727: --
728: from ra_mc_customer_trx ct,
729: ra_customer_trx_all trx,
730: ar_receivable_applications_all ra,
731: xla_upgrade_dates gps,
732: ar_mc_receivable_apps app,
808: hdr.accounting_date accounting_date,
809: hdr1.ledger_id ledger_id,
810: 3 ln_order
811: --
812: from ra_mc_customer_trx ct,
813: ra_customer_trx_all trx,
814: ar_transaction_history_all th,
815: xla_upgrade_dates gps,
816: ar_mc_transaction_history trh,
2627: );
2628:
2629: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;
2630:
2631: ELSIF (l_table_name = 'RA_MC_CUSTOMER_TRX') THEN
2632:
2633: INSERT ALL
2634: WHEN 1 = 1 THEN
2635: INTO XLA_AE_LINES
2838: hdr.accounting_date accounting_date,
2839: hdr.ledger_id ledger_id,
2840: 1 ln_order
2841: --
2842: from ra_mc_customer_trx ct,
2843: ra_customer_trx_all trx,
2844: ar_receivable_applications_all app,
2845: xla_upgrade_dates gps,
2846: ar_mc_receivable_apps ra,