APPS.DDR_BASE_UTIL_PKG dependencies on DDR_I_SYND_CNSMPTN_DATA

Line 1471: FROM DDR_I_SYND_CNSMPTN_DATA

1467: MEASURE86, MEASURE87, MEASURE88, MEASURE89, MEASURE90,
1468: MEASURE91, MEASURE92, MEASURE93, MEASURE94, MEASURE95,
1469: MEASURE96, MEASURE97, MEASURE98, MEASURE99, MEASURE100,
1470: RTL_ORG_CD,AO_HCHY_CD,ACCT_CD
1471: FROM DDR_I_SYND_CNSMPTN_DATA
1472: WHERE
1473: (MEASURE_SET, SRC_CD, NVL(PROD_KEY,'PROD'), NVL(GEO_KEY,'GEO'),
1474: NVL(CHNL_TYP_CD,'CHNL'), NVL(GEO_SUB_RGN_CD,'SUB'),
1475: NVL(GEO_RGN_CD,'RGN'), NVL(MFG_ITM_HCHY_LVL,'LVL'),

Line 1487: FROM DDR_I_SYND_CNSMPTN_DATA

1483: NVL(GEO_RGN_CD,'RGN'), NVL(MFG_ITM_HCHY_LVL,'LVL'),
1484: NVL(MFG_ITM_HCHY_CD,'HCHY'), NVL(MKT_AREA_CD,'MKT'),NVL(MKT_AREA_TYP,'MKT_TYP'),
1485: NVL(RTL_ORG_HCHY_LVL,'ORG_LVL'), NVL(RTL_ORG_HCHY_CD,'ORG_HCHY'),
1486: PERIOD_END_DATE, NVL(RTL_ORG_CD,'ORG_CD') ,NVL(AO_HCHY_CD,'AO_HCHY'),NVL(ACCT_CD, 'ACCT_CD')
1487: FROM DDR_I_SYND_CNSMPTN_DATA
1488: GROUP BY
1489: MEASURE_SET, SRC_CD, NVL(PROD_KEY,'PROD'), NVL(GEO_KEY,'GEO'),
1490: NVL(CHNL_TYP_CD,'CHNL'), NVL(GEO_SUB_RGN_CD,'SUB'),
1491: NVL(GEO_RGN_CD,'RGN'), NVL(MFG_ITM_HCHY_LVL,'LVL'),

Line 1503: DELETE FROM DDR_I_SYND_CNSMPTN_DATA

1499:
1500: -- DELETE DUPLICATE RECORDS FROM INTERFACE TABLE --
1501:
1502:
1503: DELETE FROM DDR_I_SYND_CNSMPTN_DATA
1504: WHERE
1505: (MEASURE_SET, SRC_CD, NVL(PROD_KEY,'PROD'), NVL(GEO_KEY,'GEO'),
1506: NVL(CHNL_TYP_CD,'CHNL'), NVL(GEO_SUB_RGN_CD,'SUB'),
1507: NVL(GEO_RGN_CD,'RGN'), NVL(MFG_ITM_HCHY_LVL,'LVL'),