eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BPD_ADV_MON_RPT_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 18: okx_customer_accounts_v.NAME NAME,

14: CURSOR C_Appld_Rcpts(lap_from_date DATE, lap_to_Date DATE) IS
15: /*SELECT DISTINCT okl_ext_csh_rcpts_b.check_number check_number,
16: okl_ext_csh_rcpts_b.receipt_date receipt_date,
17: okl_ext_csh_rcpts_b.remittance_amount remittance_amount,
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

Line 30: okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b

26: okl_xtl_csh_apps_b.invoice_number invoice_number,
27: okl_xtl_csh_apps_b.TRX_DATE TRX_DATE,
28: okl_xtl_csh_apps_b.amount_applied amount_applied
29: FROM okl_ext_csh_rcpts_b,okl_xtl_csh_apps_b,okl_txl_rcpt_apps_b,
30: okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
31: WHERE okl_ext_csh_rcpts_b.ID = okl_xtl_csh_apps_b.XCR_ID_DETAILS
32: AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
33: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
34: AND okc_k_headers_b.id(+) = okl_txl_rcpt_apps_b.khr_id

Line 33: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1

29: FROM okl_ext_csh_rcpts_b,okl_xtl_csh_apps_b,okl_txl_rcpt_apps_b,
30: okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
31: WHERE okl_ext_csh_rcpts_b.ID = okl_xtl_csh_apps_b.XCR_ID_DETAILS
32: AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
33: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
34: AND okc_k_headers_b.id(+) = okl_txl_rcpt_apps_b.khr_id
35: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
36: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id
37: AND okl_ext_csh_rcpts_b.Receipt_date >= NVL(lap_from_date,okl_ext_csh_rcpts_b.Receipt_date)

Line 59: ar_payment_schedules_all d, okl_trx_csh_receipt_b e, okx_customer_accounts_v f,

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
63: AND b.cash_receipt_id = g.cash_receipt_id

Line 77: okx_customer_accounts_v.NAME NAME,

73: CURSOR C_Unappld_Rcpts(lup_from_date DATE, lup_to_Date DATE) IS
74: /*SELECT DISTINCT okl_ext_csh_rcpts_b.check_number check_number,
75: okl_ext_csh_rcpts_b.receipt_date receipt_date,
76: okl_ext_csh_rcpts_b.remittance_amount remittance_amount,
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

Line 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

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
86: WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
87: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
88: AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id
89: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'

Line 87: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1

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
86: WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
87: AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
88: AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id
89: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
90: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id
91: AND okl_ext_csh_rcpts_b.Receipt_date >= NVL(lup_From_date,okl_ext_csh_rcpts_b.Receipt_date)

Line 109: okl_trx_csh_receipt_b e, okx_customer_accounts_v f

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
113: AND a.contract_number(+) = c.contract_number