APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on ALL_TAB_COLUMNS

Line 2051: FROM all_tab_columns

2047: IS
2048: /* bug 15933838 */
2049: /* SELECT column_name
2050: , data_type
2051: FROM all_tab_columns
2052: WHERE table_name = p_table_name AND owner = p_owner
2053: AND column_id > 22
2054: ORDER BY column_id; */
2055:

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 2902: FROM all_tab_columns

2898: IS
2899: /* bug 15933838 */
2900: /* SELECT column_name
2901: , data_type
2902: FROM all_tab_columns
2903: WHERE table_name = p_table_name AND owner = p_owner */
2904: /*Bug:4724150. Commented the following condition 1 as the attribute
2905: columns becomes out of range of 20 to 91 when some extraneous attributes are added*/
2906: --AND column_id BETWEEN 20 AND 91

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;