APPS.MSD_COMPOSITE_GROUPING dependencies on MSD_CS_DEFINITIONS

Line 224: from msd_cs_definitions

220:
221: -- MSD_SHIPMENT_HISTORY
222:
223: select cs_definition_id into lv_stream_id
224: from msd_cs_definitions
225: where name='MSD_SHIPMENT_HISTORY';
226:
227: OPEN shipment;
228: FETCH shipment BULK COLLECT INTO

Line 275: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b

271: COLLECT_LEVEL_ID )
272: SELECT a.cs_definition_id,
273: a.dimension_code,
274: a.collect_level_id
275: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
276: WHERE a.cs_definition_id = b.cs_definition_id
277: AND b.cs_definition_id = lv_stream_id
278: AND a.dimension_code <> 'TIM'
279: AND a.collect_flag='Y'

Line 315: from msd_cs_definitions

311:
312: -- MSD_BOOKING_HISTORY
313:
314: select cs_definition_id into lv_stream_id
315: from msd_cs_definitions
316: where name='MSD_BOOKING_HISTORY';
317:
318: OPEN booking;
319: FETCH booking BULK COLLECT INTO

Line 366: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b

362: COLLECT_LEVEL_ID )
363: SELECT a.cs_definition_id,
364: a.dimension_code,
365: a.collect_level_id
366: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
367: WHERE a.cs_definition_id = b.cs_definition_id
368: AND b.cs_definition_id = lv_stream_id
369: AND a.dimension_code <> 'TIM'
370: AND a.collect_flag='Y'

Line 415: from msd_cs_definitions

411:
412: BEGIN
413:
414: select cs_definition_id into lv_stream_id
415: from msd_cs_definitions
416: where name='MSD_MANUFACTURING_FORECAST';
417:
418: select count(*) into lv_forecast_designator
419: from ( select distinct forecast_designator from msd_mfg_forecast);

Line 471: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b

467: COLLECT_LEVEL_ID )
468: SELECT a.cs_definition_id,
469: a.dimension_code,
470: a.collect_level_id
471: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
472: WHERE a.cs_definition_id = b.cs_definition_id
473: AND b.cs_definition_id = lv_stream_id
474: AND a.dimension_code <> 'TIM'
475: AND a.collect_flag='Y'

Line 811: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b

807: FROM msd_cs_data x;
808:
809: CURSOR c1 IS
810: SELECT a.cs_definition_id,a.dimension_code,a.collect_level_id
811: FROM msd_cs_defn_dim_dtls a, msd_cs_definitions b
812: WHERE a.cs_definition_id = b.cs_definition_id
813: AND a.dimension_code <> 'TIM'
814: AND a.collect_flag='Y'
815: AND b.strict_flag='Y'

Line 1065: UPDATE MSD_CS_DEFINITIONS

1061: LOG_MESSAGE('-------APPLICATION MODE is YES---------');
1062:
1063: LOG_MESSAGE('*************FINAL OUTPUT - STARTS**************');
1064:
1065: UPDATE MSD_CS_DEFINITIONS
1066: SET COMPOSITE_GROUP_CODE = to_number(NULL);
1067:
1068:
1069: FOR j in 1..v_final_tbl.COUNT

Line 1073: UPDATE MSD_CS_DEFINITIONS

1069: FOR j in 1..v_final_tbl.COUNT
1070: LOOP
1071: LOG_MESSAGE ( 'Element '||j||': '||v_final_tbl(j).p_stream_id||', '||v_final_tbl(j).l_dimension_clause||', '||v_final_tbl(j).l_group);
1072:
1073: UPDATE MSD_CS_DEFINITIONS
1074: SET COMPOSITE_GROUP_CODE = v_final_tbl(j).l_group
1075: WHERE CS_DEFINITION_ID = v_final_tbl(j).p_stream_id;
1076:
1077: END LOOP;