DBA Data[Home] [Help]

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_SLS_FRCST_ITEM

Line 448: INSERT INTO DDR_E_SLS_FRCST_ITEM

444:
445: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
446:
447:
448: INSERT INTO DDR_E_SLS_FRCST_ITEM
449: (REC_ID, LOAD_ID, ERR_REASON,
450: FRCST_SLS_UOM, FRCST_NBR,
451: FRCST_TYP, GLBL_ITEM_ID,
452: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,

Line 511: FROM DDR_E_SLS_FRCST_ITEM

507: TRANS_DT, FRCST_NBR, FRCST_TYP, LOC_IDNT_CD,
508: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,
509: GLBL_ITEM_ID_TYP, PERIOD_TYP_FLAG,
510: LOC_IDNT_FLAG, ORG_LVL_CD, SRC_SYS_DT
511: FROM DDR_E_SLS_FRCST_ITEM
512: GROUP BY
513: TRANS_DT, FRCST_NBR, FRCST_TYP,
514: LOC_IDNT_CD, GLBL_ITEM_ID,
515: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP, PERIOD_TYP_FLAG,