APPS.OE_SERVICE_UTIL dependencies on USER_VIEWS

Line 2097: FROM user_views

2093: IF NOT (IB_ACTIVE()) THEN
2094: BEGIN
2095: SELECT 'Y'
2096: INTO l_exists
2097: FROM user_views
2098: WHERE view_name = 'CS_SYSTEMS_RG_V'
2099: AND ROWNUM < 2;
2100: END;
2101: ELSE

Line 2105: FROM user_views

2101: ELSE
2102: BEGIN
2103: SELECT 'Y'
2104: INTO l_exists
2105: FROM user_views
2106: WHERE view_name = 'CSI_SYSTEMS_RG_V'
2107: AND ROWNUM < 2;
2108: END;
2109: END IF;

Line 2174: FROM user_views

2170: IF NOT (IB_ACTIVE()) THEN
2171: BEGIN
2172: SELECT 'Y'
2173: INTO l_exists
2174: FROM user_views
2175: WHERE view_name = 'CS_SYSTEMS_RG_V'
2176: AND ROWNUM < 2;
2177: END;
2178: ELSE

Line 2182: FROM user_views

2178: ELSE
2179: BEGIN
2180: SELECT 'Y'
2181: INTO l_exists
2182: FROM user_views
2183: WHERE view_name = 'CSI_SYSTEMS_RG_V'
2184: AND ROWNUM < 2;
2185: END;
2186: END IF;

Line 2253: FROM user_views

2249: IF NOT(IB_ACTIVE()) THEN
2250: BEGIN
2251: SELECT 'Y'
2252: INTO l_exists
2253: FROM user_views
2254: WHERE view_name = 'CS_CUSTOMER_PRODUCTS_RG_V'
2255: AND ROWNUM < 2;
2256: END;
2257: ELSE

Line 2261: FROM user_views

2257: ELSE
2258: BEGIN
2259: SELECT 'Y'
2260: INTO l_exists
2261: FROM user_views
2262: WHERE view_name = 'CSI_INSTANCE_ACCTS_RG_V'
2263: AND ROWNUM < 2;
2264: END;
2265: END IF;

Line 2351: FROM user_views

2347: /* IF NOT(IB_ACTIVE()) THEN
2348: BEGIN
2349: SELECT 'Y'
2350: INTO l_exists
2351: FROM user_views
2352: WHERE view_name = 'CS_CUSTOMER_PRODUCTS_RG_V'
2353: AND ROWNUM < 2;
2354: END;
2355: ELSE

Line 2359: FROM user_views

2355: ELSE
2356: BEGIN
2357: SELECT 'Y'
2358: INTO l_exists
2359: FROM user_views
2360: WHERE view_name = 'CSI_INSTANCE_ACCTS_RG_V'
2361: AND ROWNUM < 2;
2362: END;
2363: END IF;

Line 2478: FROM user_views

2474: IF NOT (IB_ACTIVE()) THEN
2475: BEGIN
2476: SELECT 'Y'
2477: INTO l_exists
2478: FROM user_views
2479: WHERE view_name = 'CS_CUSTOMER_PRODUCTS_RG_V'
2480: AND ROWNUM < 2;
2481: END;
2482: ELSE

Line 2486: FROM user_views

2482: ELSE
2483: BEGIN
2484: SELECT 'Y'
2485: INTO l_exists
2486: FROM user_views
2487: WHERE view_name = 'CSI_INSTANCE_ACCTS_RG_V'
2488: AND ROWNUM < 2;
2489: END;
2490: END IF;