APPS.OE_SERVICE_UTIL dependencies on USER_VIEWS

Line 2057: FROM user_views

2053: IF NOT (IB_ACTIVE()) THEN
2054: BEGIN
2055: SELECT 'Y'
2056: INTO l_exists
2057: FROM user_views
2058: WHERE view_name = 'CS_SYSTEMS_RG_V'
2059: AND ROWNUM < 2;
2060: END;
2061: ELSE

Line 2065: FROM user_views

2061: ELSE
2062: BEGIN
2063: SELECT 'Y'
2064: INTO l_exists
2065: FROM user_views
2066: WHERE view_name = 'CSI_SYSTEMS_RG_V'
2067: AND ROWNUM < 2;
2068: END;
2069: END IF;

Line 2134: FROM user_views

2130: IF NOT (IB_ACTIVE()) THEN
2131: BEGIN
2132: SELECT 'Y'
2133: INTO l_exists
2134: FROM user_views
2135: WHERE view_name = 'CS_SYSTEMS_RG_V'
2136: AND ROWNUM < 2;
2137: END;
2138: ELSE

Line 2142: FROM user_views

2138: ELSE
2139: BEGIN
2140: SELECT 'Y'
2141: INTO l_exists
2142: FROM user_views
2143: WHERE view_name = 'CSI_SYSTEMS_RG_V'
2144: AND ROWNUM < 2;
2145: END;
2146: END IF;

Line 2213: FROM user_views

2209: IF NOT(IB_ACTIVE()) THEN
2210: BEGIN
2211: SELECT 'Y'
2212: INTO l_exists
2213: FROM user_views
2214: WHERE view_name = 'CS_CUSTOMER_PRODUCTS_RG_V'
2215: AND ROWNUM < 2;
2216: END;
2217: ELSE

Line 2221: FROM user_views

2217: ELSE
2218: BEGIN
2219: SELECT 'Y'
2220: INTO l_exists
2221: FROM user_views
2222: WHERE view_name = 'CSI_INSTANCE_ACCTS_RG_V'
2223: AND ROWNUM < 2;
2224: END;
2225: END IF;

Line 2311: FROM user_views

2307: /* IF NOT(IB_ACTIVE()) THEN
2308: BEGIN
2309: SELECT 'Y'
2310: INTO l_exists
2311: FROM user_views
2312: WHERE view_name = 'CS_CUSTOMER_PRODUCTS_RG_V'
2313: AND ROWNUM < 2;
2314: END;
2315: ELSE

Line 2319: FROM user_views

2315: ELSE
2316: BEGIN
2317: SELECT 'Y'
2318: INTO l_exists
2319: FROM user_views
2320: WHERE view_name = 'CSI_INSTANCE_ACCTS_RG_V'
2321: AND ROWNUM < 2;
2322: END;
2323: END IF;

Line 2437: FROM user_views

2433: IF NOT (IB_ACTIVE()) THEN
2434: BEGIN
2435: SELECT 'Y'
2436: INTO l_exists
2437: FROM user_views
2438: WHERE view_name = 'CS_CUSTOMER_PRODUCTS_RG_V'
2439: AND ROWNUM < 2;
2440: END;
2441: ELSE

Line 2445: FROM user_views

2441: ELSE
2442: BEGIN
2443: SELECT 'Y'
2444: INTO l_exists
2445: FROM user_views
2446: WHERE view_name = 'CSI_INSTANCE_ACCTS_RG_V'
2447: AND ROWNUM < 2;
2448: END;
2449: END IF;