APPS.OKL_BPD_ADV_MON_RPT_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 22: FROM AR_RECEIVABLE_APPLICATIONS_ALL

18: okx_customer_accounts_v.NAME NAME,
19: okl_ext_csh_rcpts_b.customer_number customer_number,
20: okl_ext_csh_rcpts_b.CURRENCY_CODE currency_code,
21: ( SELECT NVL(Sum(amount_applied),0)
22: FROM AR_RECEIVABLE_APPLICATIONS_ALL
23: WHERE status = 'ACC'
24: AND cash_Receipt_id = okl_ext_csh_rcpts_b.icr_id) Amount,
25: okc_k_headers_b.Contract_Number Contract_number ,
26: okl_xtl_csh_apps_b.invoice_number invoice_number,

Line 49: FROM AR_RECEIVABLE_APPLICATIONS_ALL

45: f.NAME NAME,
46: b.pay_from_customer customer_number,
47: b.CURRENCY_CODE currency_code,
48: ( SELECT NVL(Sum(amount_applied),0)
49: FROM AR_RECEIVABLE_APPLICATIONS_ALL
50: WHERE status = 'ACC'
51: AND cash_Receipt_id = a.cash_receipt_id) Amount,
52: c.Contract_Number Contract_number ,
53: a.invoice_number invoice_number,

Line 60: ar_receivable_applications_all g

56: FROM okl_receipt_applications_uv
57: WHERE cash_receipt_id = a.cash_receipt_id) amount_applied
58: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,
59: ar_payment_schedules_all d, okl_trx_csh_receipt_b e, okx_customer_accounts_v f,
60: ar_receivable_applications_all g
61: WHERE a.cash_receipt_id = b.cash_receipt_id
62: AND b.cash_receipt_id = e.cash_receipt_id
63: AND b.cash_receipt_id = g.cash_receipt_id
64: AND g.applied_payment_schedule_id = d.payment_schedule_id

Line 81: FROM AR_RECEIVABLE_APPLICATIONS_ALL

77: okx_customer_accounts_v.NAME NAME,
78: okl_ext_csh_rcpts_b.customer_number customer_number,
79: okl_ext_csh_rcpts_b.CURRENCY_CODE currency_code,
80: ( SELECT NVL(Sum(amount_applied),0)
81: FROM AR_RECEIVABLE_APPLICATIONS_ALL
82: WHERE status = 'ACC'
83: AND cash_Receipt_id = okl_ext_csh_rcpts_b.icr_id)Amount,
84: okc_k_headers_b.Contract_Number Contract_number
85: FROM okl_ext_csh_rcpts_b,okl_txl_rcpt_apps_b,okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b

Line 104: FROM AR_RECEIVABLE_APPLICATIONS_ALL

100: f.NAME NAME,
101: b.pay_from_customer customer_number,
102: b.CURRENCY_CODE currency_code,
103: ( SELECT NVL(Sum(amount_applied),0)
104: FROM AR_RECEIVABLE_APPLICATIONS_ALL
105: WHERE status = 'ACC'
106: AND cash_Receipt_id = a.cash_receipt_id) Amount,
107: c.Contract_Number Contract_number
108: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,