DBA Data[Home] [Help]

APPS.MSD_CS_COLLECTION dependencies on MSD_CS_DEFN_COLUMN_DTLS

Line 1174: select * from msd_cs_defn_column_dtls_v

1170: srccol_name varchar2(60));
1171: Type l_type_sql_struct_array is TABLE of l_type_sql_struct;
1172:
1173: CURSOR c1 IS
1174: select * from msd_cs_defn_column_dtls_v
1175: where cs_definition_id = p_cs_definition_id;
1176:
1177: CURSOR c_multi_stream IS
1178: SELECT multiple_stream_flag FROM msd_cs_definitions

Line 1183: from msd_cs_defn_column_dtls_v

1179: WHERE cs_definition_id = p_cs_definition_id;
1180:
1181: CURSOR c_cs_name IS
1182: select source_view_column_name
1183: from msd_cs_defn_column_dtls_v
1184: where cs_definition_id = p_cs_definition_id and
1185: table_column = 'CS_NAME';
1186:
1187: l_struct l_type_sql_struct_array;

Line 2088: from msd_cs_defn_column_dtls

2084: p_cs_name in varchar2) return varchar2 is
2085:
2086: Cursor C1 is
2087: select source_view_column_name
2088: from msd_cs_defn_column_dtls
2089: where
2090: cs_definition_id = p_cs_rec.cs_definition_id and
2091: table_column = 'CS_NAME';
2092: