DBA Data[Home] [Help]

APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on AR_DISTRIBUTIONS_ALL

Line 736: , ar_distributions_all ard

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
738: WHERE ct.complete_flag = 'Y'
739: and ct.customer_trx_id = ra.customer_trx_id
740: and ra.gl_date between g_period_start_date and g_period_end_date

Line 819: , ar_distributions_all ard

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
821: WHERE cr.cash_receipt_id = crh.cash_receipt_id
822: and cr.set_of_books_id = g_ledger_id
823: and crh.gl_date between g_period_start_date and g_period_end_date

Line 897: , ar_distributions_all ard

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'
899: and cr.cash_receipt_id = crh.cash_receipt_id
900: and cr.set_of_books_id = g_ledger_id
901: and crh.gl_date between g_period_start_date and g_period_end_date

Line 974: , ar_distributions_all ard

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
976: WHERE cr.cash_receipt_id = ra.cash_receipt_id
977: and cr.set_of_books_id = g_ledger_id
978: and ra.gl_date between g_period_start_date and g_period_end_date

Line 1053: , ar_distributions_all ard

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
1055: and cr.set_of_books_id = g_ledger_id
1056: and mcd.gl_date between g_period_start_date and g_period_end_date
1057: and mcd.posting_control_id = -3

Line 1131: , ar_distributions_all ard

1127: , ct.bill_to_customer_id
1128: , ps.payment_schedule_id
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

Line 1215: , ar_distributions_all ard

1211: , ps.payment_schedule_id
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