DBA Data[Home] [Help]

APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on AR_CASH_RECEIPTS_ALL

Line 816: FROM ar_cash_receipts_all cr

812: , cr.currency_code
813: , cr.pay_from_customer
814: , ps.payment_schedule_id
815: , null
816: FROM ar_cash_receipts_all cr
817: , ar_cash_receipt_history_all crh
818: , xla_events xle
819: , ar_distributions_all ard
820: , ar_payment_schedules_all ps

Line 894: FROM ar_cash_receipts_all cr

890: , cr.currency_code
891: , cr.pay_from_customer
892: , null
893: , null
894: FROM ar_cash_receipts_all cr
895: , ar_cash_receipt_history_all crh
896: , xla_events xle
897: , ar_distributions_all ard
898: WHERE cr.type = 'MISC'

Line 971: FROM ar_cash_receipts_all cr

967: , cr.currency_code
968: , cr.pay_from_customer
969: , ps.payment_schedule_id
970: , ra.applied_payment_schedule_id
971: FROM ar_cash_receipts_all cr
972: , ar_receivable_applications_all ra
973: , xla_events xle
974: , ar_distributions_all ard
975: , ar_payment_schedules_all ps

Line 1050: FROM ar_cash_receipts_all cr

1046: , cr.currency_code
1047: , cr.pay_from_customer
1048: , null
1049: , null
1050: FROM ar_cash_receipts_all cr
1051: , ar_misc_cash_distributions_all mcd
1052: , xla_events xle
1053: , ar_distributions_all ard
1054: WHERE cr.cash_receipt_id = mcd.cash_receipt_id