DBA Data[Home] [Help]

APPS.MSD_CS_COLLECTION dependencies on MSD_ST_CS_DATA_S

Line 765: select msd_st_cs_data_s.nextval,

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

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

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

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

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