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 OKL_TRX_CSH_RECEIPT_B

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 32: AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS

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
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

Line 35: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'

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)
38: AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lap_to_Date,okl_ext_csh_rcpts_b.Receipt_date)
39: ORDER BY Check_number;

Line 36: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id

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)
38: AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lap_to_Date,okl_ext_csh_rcpts_b.Receipt_date)
39: ORDER BY Check_number;
40: */

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 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 86: WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS

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'
90: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id

Line 89: AND okl_trx_csh_receipt_b.receipt_type = 'ADV'

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)
92: AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lup_To_date,okl_ext_csh_rcpts_b.Receipt_date)
93: AND NOT EXISTS (select id from okl_xtl_csh_apps_b where xcr_id_details = okl_ext_csh_rcpts_b.id)

Line 90: AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id

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)
92: AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lup_To_date,okl_ext_csh_rcpts_b.Receipt_date)
93: AND NOT EXISTS (select id from okl_xtl_csh_apps_b where xcr_id_details = okl_ext_csh_rcpts_b.id)
94: ORDER BY Check_number;

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