DBA Data[Home] [Help]

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_E_SLS_FRCST_ITEM

Line 510: INSERT INTO DDR_E_SLS_FRCST_ITEM

506: BEGIN
507: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
508:
509:
510: INSERT INTO DDR_E_SLS_FRCST_ITEM
511: (REC_ID, LOAD_ID, ERR_REASON,
512: FRCST_SLS_UOM, FRCST_NBR,
513: FRCST_TYP, GLBL_ITEM_ID,
514: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP,

Line 573: FROM DDR_E_SLS_FRCST_ITEM

569: TRANS_DT, FRCST_NBR, FRCST_TYP, LOC_IDNT_CD,
570: GLBL_ITEM_ID, RTL_SKU_ITEM_NBR,
571: GLBL_ITEM_ID_TYP, PERIOD_TYP_FLAG,
572: LOC_IDNT_FLAG, ORG_LVL_CD, SRC_SYS_DT, RTL_ORG_CD,FRCST_PURP
573: FROM DDR_E_SLS_FRCST_ITEM
574: GROUP BY
575: TRANS_DT, FRCST_NBR, FRCST_TYP,
576: LOC_IDNT_CD, GLBL_ITEM_ID,
577: RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP, PERIOD_TYP_FLAG,

Line 1199: INSERT INTO ddr_e_sls_frcst_item

1195:
1196: -- INSERT DUPLICATE RECORDS IN THE ERROR TABLE --
1197:
1198: FOR rec IN c1 LOOP --{
1199: INSERT INTO ddr_e_sls_frcst_item
1200: (crncy_cd
1201: ,day_cd
1202: ,frcst_nbr
1203: ,frcst_sls_amt