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 OKC_K_HEADERS_B

Line 25: okc_k_headers_b.Contract_Number Contract_number ,

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

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 34: AND okc_k_headers_b.id(+) = okl_txl_rcpt_apps_b.khr_id

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

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 84: okc_k_headers_b.Contract_Number Contract_number

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

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 88: AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id

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)
92: AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lup_To_date,okl_ext_csh_rcpts_b.Receipt_date)

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 127: l_Contract_No okc_k_headers_b.Contract_Number%Type DEFAULT 0;

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;
131: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();