DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on USER_SYNONYMS

Line 2058: FROM user_synonyms syn , all_tab_columns col

2054: ORDER BY column_id; */
2055:
2056: SELECT col.column_name
2057: , col.data_type
2058: FROM user_synonyms syn , all_tab_columns col
2059: WHERE syn.synonym_name = p_table_name AND col.owner = p_owner
2060: and col.owner = syn.table_owner
2061: and col.table_name = syn.table_name
2062: and col.column_id > 22

Line 2911: FROM user_synonyms syn , all_tab_columns col

2907: -- ORDER BY column_id;
2908:
2909: SELECT col.column_name
2910: , col.data_type
2911: FROM user_synonyms syn , all_tab_columns col
2912: WHERE syn.synonym_name = p_table_name AND col.owner = p_owner
2913: and col.owner = syn.table_owner
2914: and col.table_name = syn.table_name
2915: ORDER BY column_id;