[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT batch_number,
batch_name,
agreement_id,
transaction_due_date,
settlement_date,
org_id,
batch_currency,
total_netted_amt
FROM fun_net_batches
WHERE batch_id = p_batch_id;
SELECT agreement_name,
agreement_start_date,
agreement_end_date
FROM fun_net_agreements
WHERE agreement_id = cp_agreement_id;
SELECT l.currency_code
FROM gl_ledgers l,hr_operating_units ou
WHERE ou.organization_id = cp_org_id
AND ou.set_of_books_id = l.ledger_id;
SELECT pv.vendor_name supplier ,
pv.segment1 supplier_number ,
pvs.vendor_site_code supplier_site ,
ai.invoice_num invoice_number ,
ai.invoice_date invoice_date ,
ai.invoice_currency_code invoice_currency,
ai.invoice_amount invoice_amount ,
ai.base_amount ledger_amount,
nai.netted_amt netted_amount
FROM fun_net_ap_invs nai,
ap_invoices_all ai,
po_vendors pv,
po_vendor_sites_all pvs,
fun_net_suppliers_all ns
WHERE nai.batch_id = p_batch_id
AND nai.invoice_id = ai.invoice_id
AND ai.vendor_id = pv.vendor_id
AND ai.vendor_site_id = pvs.vendor_site_id
AND ns.agreement_id = cp_agreement_id
AND ns.supplier_id = ai.vendor_id
AND nvl(ns.supplier_site_id,ai.vendor_site_id) = ai.vendor_site_id
AND ns.org_id = ai.org_id
AND nai.org_id = ai.org_id
AND ai.org_id = pvs.org_id
AND nai.netted_amt <> 0
ORDER BY ns.supplier_priority, nai.ap_txn_rank;
SELECT hp.party_name customer ,
hca.account_number customer_number ,
hcs.location location ,
rct.trx_number transaction_number ,
rct.trx_date transaction_date ,
rct.invoice_currency_code transaction_currency,
rctl.amount transaction_amount,
rctl.acctd_amount ledger_amount,
nat.netted_amt netted_amount
FROM fun_net_ar_txns nat,
ra_customer_trx_all rct,
hz_parties hp,
hz_cust_accounts_all hca,
hz_cust_site_uses_all hcs,
fun_net_customers_all nc,
ra_cust_trx_line_gl_dist_all rctl
WHERE nat.batch_id = p_batch_id
AND nat.customer_trx_id = rct.customer_trx_id
AND rct.bill_to_customer_id = hca.cust_account_id
AND hca.party_id = hp.party_id
AND rct.bill_to_site_use_id = hcs.site_use_id
AND nc.agreement_id = cp_agreement_id
AND nc.cust_account_id = rct.bill_to_customer_id
AND nvl(nc.cust_site_use_id,rct.bill_to_site_use_id) = rct.bill_to_site_use_id
AND nc.org_id = rct.org_id
AND nat.org_id = rct.org_id
AND nat.org_id = hcs.org_id
AND nat.netted_amt <> 0
AND rct.customer_trx_id = rctl.customer_trx_id
AND rctl.account_class = 'REC'
AND nvl(latest_rec_flag,'N') = 'Y'
AND rct.org_id = rctl.org_id
ORDER BY nc.cust_priority, nat.ar_txn_rank;
SELECT currency_code
INTO l_func_currency
FROM gl_ledgers
WHERE ledger_id = l_ledger_id;