DBA Data[Home] [Help]

APPS.MSD_CS_COLLECTION dependencies on MSD_ST_CS_DATA_S

Line 764: select msd_st_cs_data_s.nextval,

760: LAST_UPDATE_DATE,
761: LAST_UPDATED_BY,
762: LAST_UPDATE_LOGIN
763: )
764: select msd_st_cs_data_s.nextval,
765: to_char(p_cs_rec.cs_definition_id),
766: 'SINGLE_STREAM',
767: to_char(inv.sr_instance_id),
768: inv.prd_level_id,

Line 918: (msd_st_cs_data_s.nextval, p_cs_rec.cs_definition_id, crec_data.designator,

914: created_by, creation_date, last_update_date, last_updated_by, last_update_login
915: )
916: values
917: /* Fix for designator name crec_data.designator instead of p_cs_name */
918: (msd_st_cs_data_s.nextval, p_cs_rec.cs_definition_id, crec_data.designator,
919: p_instance_id,
920: crec_data.prd_level_id, crec_data.prd_sr_level_value_pk, crec_data.prd_level_value, crec_data.prd_level_value_pk,
921: crec_data.geo_level_id, crec_data.geo_sr_level_value_pk, crec_data.geo_level_value, crec_data.geo_level_value_pk,
922: crec_data.org_level_id, crec_data.org_sr_level_value_pk, crec_data.org_level_value, crec_data.org_level_value_pk,

Line 1148: 'cs_name ) ' || ' select ' || 'msd_st_cs_Data_s.nextval, ' || p_cs_definition_id ||

1144: 'attribute_41, attribute_42, attribute_43, attribute_44, attribute_45, ' ||
1145: 'attribute_46, attribute_47, attribute_48, attribute_49, attribute_50, ' ||
1146: 'attribute_51, attribute_52, attribute_53, attribute_54, attribute_55, ' ||
1147: 'attribute_56, attribute_57, attribute_58, attribute_59, attribute_60,' ||
1148: 'cs_name ) ' || ' select ' || 'msd_st_cs_Data_s.nextval, ' || p_cs_definition_id ||
1149: ', ' || l_sql_stmt || ' from ' || p_source_view || p_db_link;
1150:
1151: return l_sql_stmt;
1152: