[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/*SELECT DISTINCT okl_ext_csh_rcpts_b.check_number check_number,
okl_ext_csh_rcpts_b.receipt_date receipt_date,
okl_ext_csh_rcpts_b.remittance_amount remittance_amount,
okx_customer_accounts_v.NAME NAME,
okl_ext_csh_rcpts_b.customer_number customer_number,
okl_ext_csh_rcpts_b.CURRENCY_CODE currency_code,
( SELECT NVL(Sum(amount_applied),0)
FROM AR_RECEIVABLE_APPLICATIONS_ALL
WHERE status = 'ACC'
AND cash_Receipt_id = okl_ext_csh_rcpts_b.icr_id) Amount,
okc_k_headers_b.Contract_Number Contract_number ,
okl_xtl_csh_apps_b.invoice_number invoice_number,
okl_xtl_csh_apps_b.TRX_DATE TRX_DATE,
okl_xtl_csh_apps_b.amount_applied amount_applied
FROM okl_ext_csh_rcpts_b,okl_xtl_csh_apps_b,okl_txl_rcpt_apps_b,
okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
WHERE okl_ext_csh_rcpts_b.ID = okl_xtl_csh_apps_b.XCR_ID_DETAILS
AND okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
AND okc_k_headers_b.id(+) = okl_txl_rcpt_apps_b.khr_id
AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id
AND okl_ext_csh_rcpts_b.Receipt_date >= NVL(lap_from_date,okl_ext_csh_rcpts_b.Receipt_date)
AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lap_to_Date,okl_ext_csh_rcpts_b.Receipt_date)
ORDER BY Check_number;
SELECT DISTINCT a.receipt_number check_number,
b.receipt_date receipt_date,
b.amount remittance_amount,
f.NAME NAME,
b.pay_from_customer customer_number,
b.CURRENCY_CODE currency_code,
( SELECT NVL(Sum(amount_applied),0)
FROM AR_RECEIVABLE_APPLICATIONS_ALL
WHERE status = 'ACC'
AND cash_Receipt_id = a.cash_receipt_id) Amount,
c.Contract_Number Contract_number ,
a.invoice_number invoice_number,
d.trx_date trx_date,
( SELECT NVL(SUM(a.line_applied + a.tax_applied), 0)
FROM okl_receipt_applications_uv
WHERE cash_receipt_id = a.cash_receipt_id) amount_applied
FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,
ar_payment_schedules_all d, okl_trx_csh_receipt_b e, okx_customer_accounts_v f,
ar_receivable_applications_all g
WHERE a.cash_receipt_id = b.cash_receipt_id
AND b.cash_receipt_id = e.cash_receipt_id
AND b.cash_receipt_id = g.cash_receipt_id
AND g.applied_payment_schedule_id = d.payment_schedule_id
AND b.pay_from_customer = f.ID1
AND a.contract_number(+) = c.contract_number
AND e.receipt_type = 'ADV'
AND b.Receipt_date >= NVL(null,b.Receipt_date)
AND b.Receipt_date <= NVL(null,b.Receipt_date)
ORDER BY Check_number;
/*SELECT DISTINCT okl_ext_csh_rcpts_b.check_number check_number,
okl_ext_csh_rcpts_b.receipt_date receipt_date,
okl_ext_csh_rcpts_b.remittance_amount remittance_amount,
okx_customer_accounts_v.NAME NAME,
okl_ext_csh_rcpts_b.customer_number customer_number,
okl_ext_csh_rcpts_b.CURRENCY_CODE currency_code,
( SELECT NVL(Sum(amount_applied),0)
FROM AR_RECEIVABLE_APPLICATIONS_ALL
WHERE status = 'ACC'
AND cash_Receipt_id = okl_ext_csh_rcpts_b.icr_id)Amount,
okc_k_headers_b.Contract_Number Contract_number
FROM okl_ext_csh_rcpts_b,okl_txl_rcpt_apps_b,okx_customer_accounts_v,okc_k_headers_b, okl_trx_csh_receipt_b
WHERE okl_trx_csh_receipt_b.id = okl_txl_rcpt_apps_b.RCT_ID_DETAILS
AND okl_txl_rcpt_apps_b.ILE_ID = okx_customer_accounts_v.ID1
AND okc_k_headers_b.id (+) = okl_txl_rcpt_apps_b.khr_id
AND okl_trx_csh_receipt_b.receipt_type = 'ADV'
AND okl_ext_csh_rcpts_b.RCT_ID = okl_trx_csh_receipt_b.id
AND okl_ext_csh_rcpts_b.Receipt_date >= NVL(lup_From_date,okl_ext_csh_rcpts_b.Receipt_date)
AND okl_ext_csh_rcpts_b.Receipt_date <= NVL(lup_To_date,okl_ext_csh_rcpts_b.Receipt_date)
AND NOT EXISTS (select id from okl_xtl_csh_apps_b where xcr_id_details = okl_ext_csh_rcpts_b.id)
ORDER BY Check_number;
SELECT DISTINCT a.receipt_number check_number,
b.receipt_date receipt_date,
b.amount remittance_amount,
f.NAME NAME,
b.pay_from_customer customer_number,
b.CURRENCY_CODE currency_code,
( SELECT NVL(Sum(amount_applied),0)
FROM AR_RECEIVABLE_APPLICATIONS_ALL
WHERE status = 'ACC'
AND cash_Receipt_id = a.cash_receipt_id) Amount,
c.Contract_Number Contract_number
FROM okl_receipt_applications_uv a, ar_cash_receipts_all b, okc_k_headers_b c,
okl_trx_csh_receipt_b e, okx_customer_accounts_v f
WHERE a.cash_receipt_id = b.cash_receipt_id
AND b.cash_receipt_id = e.cash_receipt_id
AND b.pay_from_customer = f.ID1
AND a.contract_number(+) = c.contract_number
AND e.receipt_type = 'ADV'
AND b.Receipt_date >= NVL(null,b.Receipt_date)
AND b.Receipt_date <= NVL(null,b.Receipt_date)
AND NOT EXISTS (select id from okl_txl_rcpt_apps_b where rct_id_details = e.id)
ORDER BY Check_number;
SELECT name
FROM hr_operating_units
WHERE organization_id = l_org_id;