DBA Data[Home] [Help]

APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 1148: ar_cash_receipts_all acr,

1144: acr.receipt_number,
1145: acr.cash_receipt_id,
1146: acr.amount
1147: from ar_receivable_applications_all ara,
1148: ar_cash_receipts_all acr,
1149: --ra_customers rc, ----Bug#4476059 Quick Change
1150: hz_cust_accounts hzca1,
1151: hz_parties hzp1,
1152: ra_customer_trx_all rct

Line 1167: ar_cash_receipts_all acr,

1163: p_customer_trx_id NUMBER ,
1164: p_cash_receipt_id NUMBER )IS
1165: SELECT receipt_desc_type ,NVL(ficr.amount,0) amount
1166: FROM fv_interim_cash_receipts_all ficr,
1167: ar_cash_receipts_all acr,
1168: ar_cash_receipt_history_all acrh
1169: WHERE ficr.receipt_number = p_receipt_number
1170: AND ficr.customer_trx_id = p_customer_trx_id
1171: AND ficr.set_of_books_id = vp_sob_id

Line 1187: ar_cash_receipts_all acr,

1183: acr.receipt_number,
1184: ara.cash_receipt_id,
1185: aps.class
1186: from ar_receivable_applications_all ara,
1187: ar_cash_receipts_all acr,
1188: ar_payment_schedules_all aps
1189: where ara.cash_receipt_id = acr.cash_receipt_id
1190: and acr.set_of_books_id = vp_sob_id
1191: and nvl(ara.days_late,0) >= 0