DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on ALL_TAB_COLUMNS

Line 2112: FROM all_tab_columns

2108: CURSOR column_csr (p_table_name VARCHAR2, p_owner VARCHAR2)
2109: IS
2110: SELECT column_name
2111: , data_type
2112: FROM all_tab_columns
2113: WHERE table_name = p_table_name AND owner = p_owner
2114: AND column_id > 22
2115: ORDER BY column_id;
2116:

Line 2952: FROM all_tab_columns

2948: CURSOR column_csr (p_table_name VARCHAR2, p_owner VARCHAR2)
2949: IS
2950: SELECT column_name
2951: , data_type
2952: FROM all_tab_columns
2953: WHERE table_name = p_table_name AND owner = p_owner
2954: /*Bug:4724150. Commented the following condition 1 as the attribute
2955: columns becomes out of range of 20 to 91 when some extraneous attributes are added*/
2956: --AND column_id BETWEEN 20 AND 91