DBA Data[Home] [Help]

APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on RA_CUSTOMER_TRX_ALL

Line 653: ra_customer_trx_all ct

649: , ct.bill_to_customer_id
650: , ps.payment_schedule_id
651: , NULL
652: from
653: ra_customer_trx_all ct
654: ,ra_cust_trx_line_gl_dist_all gld
655: ,xla_events xle
656: ,ar_payment_schedules_all ps
657: WHERE ct.complete_flag = 'Y'

Line 733: from ra_customer_trx_all ct

729: , ct.invoice_currency_code
730: , ct.bill_to_customer_id
731: , ps.payment_schedule_id
732: , ra.applied_payment_schedule_id
733: from ra_customer_trx_all ct
734: , ar_receivable_applications_all ra
735: , xla_events xle
736: , ar_distributions_all ard
737: , ar_payment_schedules_all ps

Line 1133: , ra_customer_trx_all ct

1129: , null
1130: FROM ar_adjustments_all adj
1131: , ar_distributions_all ard
1132: , xla_events xle
1133: , ra_customer_trx_all ct
1134: , ar_payment_schedules_all ps
1135: WHERE adj.set_of_books_id = g_ledger_id
1136: and adj.gl_date between g_period_start_date and g_period_end_date
1137: and adj.posting_control_id = -3

Line 1216: , ra_customer_trx_all ct

1212: , null
1213: FROM ar_transaction_history_all th
1214: , xla_events xle
1215: , ar_distributions_all ard
1216: , ra_customer_trx_all ct
1217: , ar_payment_schedules_all ps
1218: WHERE th.gl_date between g_period_start_date and g_period_end_date
1219: and th.posting_control_id = -3
1220: and NVL(th.postable_flag, 'Y') = 'Y'