APPS.DDR_BASE_UTIL_PKG dependencies on DDR_S_RTL_ORDR_ITEM

Line 1094: FROM ddr_s_rtl_ordr_item

1090: v_FUNC_MSG VARCHAR2(1) := 'N';
1091:
1092: CURSOR c1 IS
1093: SELECT *
1094: FROM ddr_s_rtl_ordr_item
1095: WHERE (day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id)
1096: IN (SELECT day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
1097: FROM ddr_s_rtl_ordr_item
1098: GROUP BY day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id

Line 1097: FROM ddr_s_rtl_ordr_item

1093: SELECT *
1094: FROM ddr_s_rtl_ordr_item
1095: WHERE (day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id)
1096: IN (SELECT day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
1097: FROM ddr_s_rtl_ordr_item
1098: GROUP BY day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
1099: HAVING count(*) > 1)
1100: FOR UPDATE;
1101: BEGIN

Line 1169: DELETE ddr_s_rtl_ordr_item

1165: ,'Duplicate record - Staging'
1166: );
1167:
1168: -- delete duplicate records from staging table --
1169: DELETE ddr_s_rtl_ordr_item
1170: WHERE CURRENT OF c1;
1171:
1172: END LOOP; --}
1173: