DBA Data[Home] [Help]

APPS.OKL_EQUIPMENT_EXCHANGE_PVT dependencies on OKX_VENDORS_V

Line 340: FROM OKX_VENDORS_V

336: (p_vendor_id IN VARCHAR2)
337: RETURN VARCHAR2 aS
338: CURSOR okl_vendor_lkp_csr(p_vendor_id IN VARCHAR2) IS
339: SELECT NAME
340: FROM OKX_VENDORS_V
341: WHERE ID1=p_vendor_id;
342: l_vendor_name VARCHAR2(240);
343: BEGIN
344: OPEN okl_vendor_lkp_csr(p_vendor_id);

Line 1154: FROM OKX_VENDORS_V

1150: AND B.CLE_ID = c_model_line_id;
1151:
1152: CURSOR c_new_vendor(c_id NUMBER) IS
1153: SELECT ID2
1154: FROM OKX_VENDORS_V
1155: where id1=c_id;
1156:
1157: CURSOR c_asset_id1 (c_khr_id NUMBER,c_asset_id NUMBER,c_Asset_number VARCHAR2) IS
1158: SELECT CLE.ID ID1