APPS.OKL_BPD_ADV_MON_RPT_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 58: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,

54: d.trx_date trx_date,
55: ( SELECT NVL(SUM(a.line_applied + a.tax_applied), 0)
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

Line 108: FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,

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,
109: okl_trx_csh_receipt_b e, okx_customer_accounts_v f
110: WHERE a.cash_receipt_id = b.cash_receipt_id
111: AND b.cash_receipt_id = e.cash_receipt_id
112: AND b.pay_from_customer = f.ID1

Line 126: l_Cust_No AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%Type DEFAULT 0;

122: FROM hr_operating_units
123: WHERE organization_id = l_org_id;
124:
125: l_receipt_no OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%Type DEFAULT 0;
126: l_Cust_No AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%Type DEFAULT 0;
127: l_Contract_No okc_k_headers_b.Contract_Number%Type DEFAULT 0;
128:
129: l_from_date DATE;
130: l_to_date DATE;