DBA Data[Home] [Help]

APPS.CZ_PB_MGR dependencies on USER_SYNONYMS

Line 1127: FROM user_synonyms syn, all_tab_columns col

1123: IS
1124: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
1125: --the logical column for a logical object than a physical columns
1126: SELECT col.column_name
1127: FROM user_synonyms syn, all_tab_columns col
1128: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
1129: AND col.owner = syn.table_owner
1130: AND col.table_name = syn.table_name;
1131:

Line 1311: FROM user_synonyms syn, all_tab_columns col

1307: IS
1308: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
1309: --the logical column for a logical object than a physical columns
1310: SELECT col.column_name
1311: FROM user_synonyms syn, all_tab_columns col
1312: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
1313: AND col.owner = syn.table_owner
1314: AND col.table_name = syn.table_name;
1315:

Line 2051: FROM user_synonyms syn, all_tab_columns col

2047: IS
2048: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
2049: --the logical column for a logical object than a physical columns
2050: SELECT col.column_name
2051: FROM user_synonyms syn, all_tab_columns col
2052: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
2053: AND col.owner = syn.table_owner
2054: AND col.table_name = syn.table_name;
2055:

Line 2176: FROM user_synonyms syn, all_tab_columns col

2172: IS
2173: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
2174: --the logical column for a logical object than a physical columns
2175: SELECT col.column_name
2176: FROM user_synonyms syn, all_tab_columns col
2177: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
2178: AND col.owner = syn.table_owner
2179: AND col.table_name = syn.table_name;
2180:

Line 2300: FROM user_synonyms syn, all_tab_columns col

2296: IS
2297: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
2298: --the logical column for a logical object than a physical columns
2299: SELECT col.column_name
2300: FROM user_synonyms syn, all_tab_columns col
2301: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
2302: AND col.owner = syn.table_owner
2303: AND col.table_name = syn.table_name;
2304:

Line 2423: FROM user_synonyms syn, all_tab_columns col

2419: IS
2420: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
2421: --the logical column for a logical object than a physical columns
2422: SELECT col.column_name
2423: FROM user_synonyms syn, all_tab_columns col
2424: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
2425: AND col.owner = syn.table_owner
2426: AND col.table_name = syn.table_name;
2427:

Line 2543: FROM user_synonyms syn, all_tab_columns col

2539: IS
2540: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
2541: --the logical column for a logical object than a physical columns
2542: SELECT col.column_name
2543: FROM user_synonyms syn, all_tab_columns col
2544: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
2545: AND col.owner = syn.table_owner
2546: AND col.table_name = syn.table_name;
2547:

Line 2663: FROM user_synonyms syn, all_tab_columns col

2659: IS
2660: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
2661: --the logical column for a logical object than a physical columns
2662: SELECT col.column_name
2663: FROM user_synonyms syn, all_tab_columns col
2664: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
2665: AND col.owner = syn.table_owner
2666: AND col.table_name = syn.table_name;
2667:

Line 2785: FROM user_synonyms syn, all_tab_columns col

2781: IS
2782: --Bug15915777: SKM: Chnnages based on 12.2.1 EV (Online patching). Should access
2783: --the logical column for a logical object than a physical columns
2784: SELECT col.column_name
2785: FROM user_synonyms syn, all_tab_columns col
2786: WHERE UPPER(syn.synonym_name) = UPPER(LTRIM(RTRIM(par_table_name)))
2787: AND col.owner = syn.table_owner
2788: AND col.table_name = syn.table_name;
2789: