DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_BPD_TLD_AR_LINES_V

Line 2330: FROM okl_bpd_tld_ar_lines_v tld,

2326: UNION ALL
2327: SELECT cra.receipt_date txn_date,
2328: sum(raa.line_applied) txn_amount, -- 4884843, 4872370
2329: 'R' txn_type
2330: FROM okl_bpd_tld_ar_lines_v tld,
2331: ar_payment_schedules_all aps,
2332: ar_receivable_applications_all raa,
2333: ar_cash_receipts_all cra,
2334: okl_strm_type_v sty

Line 2352: FROM okl_bpd_tld_ar_lines_v tld,

2348: UNION ALL
2349: SELECT cm.trx_date txn_date,
2350: sum(raa.line_applied) txn_amount,
2351: 'R' txn_type
2352: FROM okl_bpd_tld_ar_lines_v tld,
2353: ar_payment_schedules_all aps,
2354: ar_receivable_applications_all raa,
2355: ra_customer_trx_all cm,
2356: okl_strm_type_v sty

Line 2374: FROM okl_bpd_tld_ar_lines_v tld,

2370: UNION ALL
2371: SELECT adj.apply_date txn_date,
2372: sum( -1 * NVL(adj.amount,0)) txn_amount,
2373: 'R' txn_type
2374: FROM okl_bpd_tld_ar_lines_v tld,
2375: ar_payment_schedules_all aps,
2376: ar_adjustments_all adj,
2377: okl_strm_type_v sty
2378: WHERE tld.trx_status_code = 'PROCESSED'