APPS.MSD_COMPOSITE_GROUPING dependencies on MSD_CS_DTLS_TEMP

Line 139: UPDATE MSD_CS_DTLS_TEMP

135: OPEN a(p_cs_definition_id,p_dimension_code);
136:
137: FETCH a INTO lv_collect_level_id;
138: LOG_DEBUG('The value of lv_collect_level_id is '||lv_collect_level_id);
139: UPDATE MSD_CS_DTLS_TEMP
140: SET COLLECT_LEVEL_ID = lv_collect_level_id
141: WHERE DIMENSION_CODE = p_dimension_code
142: AND CS_DEFINITION_ID = p_cs_definition_id;
143:

Line 268: INSERT INTO MSD_CS_DTLS_TEMP

264:
265: END IF;
266: CLOSE shipment;
267:
268: INSERT INTO MSD_CS_DTLS_TEMP
269: ( CS_DEFINITION_ID,
270: DIMENSION_CODE,
271: COLLECT_LEVEL_ID )
272: SELECT a.cs_definition_id,

Line 359: INSERT INTO MSD_CS_DTLS_TEMP

355:
356: END IF;
357: CLOSE booking;
358:
359: INSERT INTO MSD_CS_DTLS_TEMP
360: ( CS_DEFINITION_ID,
361: DIMENSION_CODE,
362: COLLECT_LEVEL_ID )
363: SELECT a.cs_definition_id,

Line 464: INSERT INTO MSD_CS_DTLS_TEMP

460:
461: END IF;
462: CLOSE mfg_forecast;
463:
464: INSERT INTO MSD_CS_DTLS_TEMP
465: ( CS_DEFINITION_ID,
466: DIMENSION_CODE,
467: COLLECT_LEVEL_ID )
468: SELECT a.cs_definition_id,

Line 824: FROM MSD_CS_DTLS_TEMP

820: --need to elimintate custom streams having multiple streams with more than one designator.
821:
822: CURSOR c2 IS
823: SELECT cs_definition_id,dimension_code
824: FROM MSD_CS_DTLS_TEMP
825: WHERE COLLECT_LEVEL_ID IS NULL;
826:
827: TYPE mastcurtyp IS REF CURSOR;
828: c3 mastcurtyp;

Line 852: from MSD_CS_DTLS_TEMP )

848: LEAD(collect_level_id,5) over (partition by cs_definition_id order by collect_level_id) as dim6,
849: LEAD(collect_level_id,6) over (partition by cs_definition_id order by collect_level_id) as dim7,
850: LEAD(collect_level_id,7) over (partition by cs_definition_id order by collect_level_id) as dim8,
851: row_number() over (partition by cs_definition_id order by collect_level_id) as rno
852: from MSD_CS_DTLS_TEMP )
853: WHERE rno=1
854: ORDER BY dim1,dim2,dim3,dim4,dim5,dim6,dim7,dim8;
855: */
856:

Line 862: ----- populating the temporary tables MSD_DISTINCT_DIM_VAL_TEMP and MSD_CS_DTLS_TEMP -------

858:
859: v_threshold_overlap := p_threshold_overlap;
860: v_threshold_overlap :=0.85; -- Hardcoded Threshold percentage
861:
862: ----- populating the temporary tables MSD_DISTINCT_DIM_VAL_TEMP and MSD_CS_DTLS_TEMP -------
863:
864: --TRUNCATE TABLE MSD_DISTINCT_DIM_VAL_TEMP;
865:
866: OPEN c;

Line 908: --TRUNCATE TABLE MSD_CS_DTLS_TEMP;

904:
905: END IF;
906: CLOSE c;
907:
908: --TRUNCATE TABLE MSD_CS_DTLS_TEMP;
909:
910: OPEN c1;
911: FETCH c1 BULK COLLECT INTO
912: lb_cs_definition_id,

Line 919: INSERT INTO MSD_CS_DTLS_TEMP

915:
916: IF c1%ROWCOUNT > 0 THEN
917:
918: FORALL j IN lb_cs_definition_id.FIRST..lb_cs_definition_id.LAST
919: INSERT INTO MSD_CS_DTLS_TEMP
920: ( CS_DEFINITION_ID,
921: DIMENSION_CODE,
922: COLLECT_LEVEL_ID )
923: VALUES

Line 970: ||' from MSD_CS_DTLS_TEMP ) '

966: ||' LEAD(collect_level_id,5) over (partition by cs_definition_id order by collect_level_id) as dim6, '
967: ||' LEAD(collect_level_id,6) over (partition by cs_definition_id order by collect_level_id) as dim7, '
968: ||' LEAD(collect_level_id,7) over (partition by cs_definition_id order by collect_level_id) as dim8, '
969: ||' row_number() over (partition by cs_definition_id order by collect_level_id) as rno '
970: ||' from MSD_CS_DTLS_TEMP ) '
971: ||' WHERE rno=1 '
972: ||' ORDER BY dim1,dim2,dim3,dim4,dim5,dim6,dim7,dim8 ';
973:
974: /* Populating the pl/sql table for all the possible streams to be grouped */