APPS.DDR_BASE_UTIL_PKG dependencies on DDR_S_SLS_FRCST_ITEM

Line 1187: FROM ddr_s_sls_frcst_item

1183: v_FUNC_MSG VARCHAR2(1) := 'N';
1184:
1185: CURSOR c1 IS
1186: SELECT *
1187: FROM ddr_s_sls_frcst_item
1188: WHERE (frcst_vrsn,day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,frcst_purp,frcst_typ)
1189: IN (SELECT frcst_vrsn,day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,frcst_purp,frcst_typ
1190: FROM ddr_s_sls_frcst_item
1191: GROUP BY frcst_vrsn,day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,frcst_purp,frcst_typ

Line 1190: FROM ddr_s_sls_frcst_item

1186: SELECT *
1187: FROM ddr_s_sls_frcst_item
1188: WHERE (frcst_vrsn,day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,frcst_purp,frcst_typ)
1189: IN (SELECT frcst_vrsn,day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,frcst_purp,frcst_typ
1190: FROM ddr_s_sls_frcst_item
1191: GROUP BY frcst_vrsn,day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,frcst_purp,frcst_typ
1192: HAVING count(*) > 1)
1193: FOR UPDATE;
1194: BEGIN

Line 1270: DELETE ddr_s_sls_frcst_item

1266: ,rec.frcst_purp
1267: );
1268:
1269: -- delete duplicate records from staging table --
1270: DELETE ddr_s_sls_frcst_item
1271: WHERE CURRENT OF c1;
1272:
1273: END LOOP; --}
1274: