DBA Data[Home] [Help]

APPS.JTY_ASSIGN_BULK_PUB dependencies on ALL_TAB_COLUMNS

Line 92: FROM all_tab_columns

88:
89:
90: CURSOR c1(p_table_name IN VARCHAR2, p_owner IN VARCHAR2) is
91: SELECT column_name
92: FROM all_tab_columns
93: WHERE table_name = p_table_name
94: AND owner = p_owner
95: AND column_name not in ('SECURITY_GROUP_ID', 'OBJECT_VERSION_NUMBER', 'WORKER_ID', 'LAST_UPDATE_DATE',
96: 'LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY', 'LAST_UPDATE_LOGIN', 'REQUEST_ID',

Line 316: FROM all_tab_columns

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

Line 2103: FROM all_tab_columns

2099: ORDER BY jtqp.relation_product DESC;
2100:
2101: CURSOR c1(p_table_name IN VARCHAR2, p_owner IN VARCHAR2) is
2102: SELECT column_name
2103: FROM all_tab_columns
2104: WHERE table_name = p_table_name
2105: AND owner = p_owner
2106: AND column_name not in ('SECURITY_GROUP_ID', 'OBJECT_VERSION_NUMBER', 'WORKER_ID', 'LAST_UPDATE_DATE',
2107: 'LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY', 'LAST_UPDATE_LOGIN', 'REQUEST_ID',