DBA Data[Home] [Help]

APPS.JTY_ASSIGN_BULK_PUB dependencies on ALL_TAB_COLUMNS

Line 80: FROM all_tab_columns

76:
77:
78: CURSOR c1(p_table_name IN VARCHAR2, p_owner IN VARCHAR2) is
79: SELECT column_name
80: FROM all_tab_columns
81: WHERE table_name = p_table_name
82: AND owner = p_owner
83: AND column_name not in ('SECURITY_GROUP_ID', 'OBJECT_VERSION_NUMBER', 'WORKER_ID', 'LAST_UPDATE_DATE',
84: 'LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY', 'LAST_UPDATE_LOGIN', 'REQUEST_ID',

Line 319: FROM all_tab_columns

315:
316:
317: CURSOR c1(p_table_name IN VARCHAR2, p_owner IN VARCHAR2) is
318: SELECT column_name
319: FROM all_tab_columns
320: WHERE table_name = p_table_name
321: AND owner = p_owner
322: AND column_name not in ('SECURITY_GROUP_ID', 'OBJECT_VERSION_NUMBER', 'WORKER_ID', 'LAST_UPDATE_DATE',
323: 'LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY', 'LAST_UPDATE_LOGIN', 'REQUEST_ID',

Line 2241: FROM all_tab_columns

2237: ORDER BY jtqp.relation_product DESC;
2238:
2239: CURSOR c1(p_table_name IN VARCHAR2, p_owner IN VARCHAR2) is
2240: SELECT column_name
2241: FROM all_tab_columns
2242: WHERE table_name = p_table_name
2243: AND owner = p_owner
2244: AND column_name not in ('SECURITY_GROUP_ID', 'OBJECT_VERSION_NUMBER', 'WORKER_ID', 'LAST_UPDATE_DATE',
2245: 'LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY', 'LAST_UPDATE_LOGIN', 'REQUEST_ID',