APPS.OKL_FUNDING_PVT dependencies on OKX_VENDOR_SITES_V

Line 2238: from okx_vendor_sites_v vs

2234: and a.funding_type_code ='EXPENSE'
2235: and b.amount > 0 --?
2236: and b.khr_id = p_contract_id
2237: and exists (select null
2238: from okx_vendor_sites_v vs
2239: where vs.id1 = a.ipvs_id
2240: and vs.id1 = p_vendor_site_id)
2241: ;
2242:

Line 2327: select vendor_id from okx_vendor_sites_v

2323:
2324:
2325: CURSOR cv1 (p_vendor_site_id NUMBER)
2326: IS
2327: select vendor_id from okx_vendor_sites_v
2328: where id1 = to_char(p_vendor_site_id)
2329: ;
2330:
2331: CURSOR c (p_contract_id NUMBER, p_vendor_id NUMBER, p_rle_code VARCHAR2)

Line 3399: from okx_vendor_sites_v vs

3395: and a.funding_type_code ='EXPENSE'
3396: and b.amount > 0 --?
3397: and b.khr_id = p_contract_id
3398: and exists (select null
3399: from okx_vendor_sites_v vs
3400: where vs.id1 = a.ipvs_id
3401: and vs.id1 = p_vendor_site_id)
3402: ;
3403:

Line 6352: okx_vendor_sites_v sites

6348: ) kle_amt
6349: FROM okl_assets_lov_uv a,
6350: okc_k_party_roles_b cpl,
6351: okc_k_lines_b LN,
6352: okx_vendor_sites_v sites
6353: WHERE a.chr_id = p_khr_id
6354: AND cpl.rle_code = 'OKL_VENDOR'
6355: AND cpl.chr_id IS NULL
6356: AND cpl.dnz_chr_id = a.chr_id

Line 6931: l_vendor_site_code OKX_VENDOR_SITES_V.NAME%TYPE;

6927:
6928: l_amount okl_trx_ap_invoices_b.AMOUNT%TYPE;
6929:
6930: l_ipvs_id okl_trx_ap_invoices_b.IPVS_ID%TYPE;
6931: l_vendor_site_code OKX_VENDOR_SITES_V.NAME%TYPE;
6932:
6933: l_PAY_GROUP_LOOKUP_CODE OKL_TRX_AP_INVOICES_B.PAY_GROUP_LOOKUP_CODE%TYPE;
6934: l_NETTABLE_YN OKL_TRX_AP_INVOICES_B.NETTABLE_YN%TYPE;
6935:

Line 6975: from OKX_VENDOR_SITES_V a

6971:
6972: CURSOR c_vendor_site (p_ipvs_id NUMBER)
6973: IS
6974: select a.name
6975: from OKX_VENDOR_SITES_V a
6976: where a.id1 = p_ipvs_id
6977: ;
6978:
6979: --- vpanwar 21/02/2007 Added

Line 7239: FROM okx_vendor_sites_v

7235: CURSOR cv1(
7236: p_vendor_site_id NUMBER
7237: ) IS
7238: SELECT vendor_id
7239: FROM okx_vendor_sites_v
7240: WHERE id1 = TO_CHAR(p_vendor_site_id);
7241:
7242: --
7243: --

Line 8372: select vendor_id from okx_vendor_sites_v

8368:
8369:
8370: CURSOR cv1 (p_vendor_site_id NUMBER)
8371: IS
8372: select vendor_id from okx_vendor_sites_v
8373: where id1 = to_char(p_vendor_site_id)
8374: ;
8375:
8376: BEGIN