APPS.OKL_FUNDING_PVT dependencies on OKX_VENDOR_SITES_V

Line 2212: from okx_vendor_sites_v vs

2208: and a.funding_type_code ='EXPENSE'
2209: and b.amount > 0 --?
2210: and b.khr_id = p_contract_id
2211: and exists (select null
2212: from okx_vendor_sites_v vs
2213: where vs.id1 = a.ipvs_id
2214: and vs.id1 = p_vendor_site_id)
2215: ;
2216:

Line 2300: select vendor_id from okx_vendor_sites_v

2296:
2297:
2298: CURSOR cv1 (p_vendor_site_id NUMBER)
2299: IS
2300: select vendor_id from okx_vendor_sites_v
2301: where id1 = to_char(p_vendor_site_id)
2302: ;
2303:
2304: CURSOR c (p_contract_id NUMBER, p_vendor_id NUMBER, p_rle_code VARCHAR2)

Line 3269: from okx_vendor_sites_v vs

3265: and a.funding_type_code ='EXPENSE'
3266: and b.amount > 0 --?
3267: and b.khr_id = p_contract_id
3268: and exists (select null
3269: from okx_vendor_sites_v vs
3270: where vs.id1 = a.ipvs_id
3271: and vs.id1 = p_vendor_site_id)
3272: ;
3273:

Line 6195: okx_vendor_sites_v sites

6191: ) kle_amt
6192: FROM okl_assets_lov_uv a,
6193: okc_k_party_roles_b cpl,
6194: okc_k_lines_b LN,
6195: okx_vendor_sites_v sites
6196: WHERE a.chr_id = p_khr_id
6197: AND cpl.rle_code = 'OKL_VENDOR'
6198: AND cpl.chr_id IS NULL
6199: AND cpl.dnz_chr_id = a.chr_id

Line 6774: l_vendor_site_code OKX_VENDOR_SITES_V.NAME%TYPE;

6770:
6771: l_amount okl_trx_ap_invoices_b.AMOUNT%TYPE;
6772:
6773: l_ipvs_id okl_trx_ap_invoices_b.IPVS_ID%TYPE;
6774: l_vendor_site_code OKX_VENDOR_SITES_V.NAME%TYPE;
6775:
6776: l_PAY_GROUP_LOOKUP_CODE OKL_TRX_AP_INVOICES_B.PAY_GROUP_LOOKUP_CODE%TYPE;
6777: l_NETTABLE_YN OKL_TRX_AP_INVOICES_B.NETTABLE_YN%TYPE;
6778:

Line 6818: from OKX_VENDOR_SITES_V a

6814:
6815: CURSOR c_vendor_site (p_ipvs_id NUMBER)
6816: IS
6817: select a.name
6818: from OKX_VENDOR_SITES_V a
6819: where a.id1 = p_ipvs_id
6820: ;
6821:
6822: --- vpanwar 21/02/2007 Added

Line 7082: FROM okx_vendor_sites_v

7078: CURSOR cv1(
7079: p_vendor_site_id NUMBER
7080: ) IS
7081: SELECT vendor_id
7082: FROM okx_vendor_sites_v
7083: WHERE id1 = TO_CHAR(p_vendor_site_id);
7084:
7085: --
7086: --

Line 8155: select vendor_id from okx_vendor_sites_v

8151:
8152:
8153: CURSOR cv1 (p_vendor_site_id NUMBER)
8154: IS
8155: select vendor_id from okx_vendor_sites_v
8156: where id1 = to_char(p_vendor_site_id)
8157: ;
8158:
8159: BEGIN