APPS.DDR_BASE_UTIL_PKG dependencies on DDR_S_RTL_SHIP_ITEM

Line 988: FROM ddr_s_rtl_ship_item

984: v_FUNC_MSG VARCHAR2(1) := 'N';
985:
986: CURSOR c1 IS
987: SELECT *
988: FROM ddr_s_rtl_ship_item
989: WHERE
990: (day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,ship_to_bsns_unit_id)
991: IN (SELECT day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,ship_to_bsns_unit_id
992: FROM ddr_s_rtl_ship_item

Line 992: FROM ddr_s_rtl_ship_item

988: FROM ddr_s_rtl_ship_item
989: WHERE
990: (day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,ship_to_bsns_unit_id)
991: IN (SELECT day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,ship_to_bsns_unit_id
992: FROM ddr_s_rtl_ship_item
993: GROUP BY day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id,ship_to_bsns_unit_id
994: HAVING count(*) > 1)
995: FOR UPDATE;
996: BEGIN

Line 1076: DELETE ddr_s_rtl_ship_item

1072: ,rec.ship_cost_lcl
1073: );
1074:
1075: -- delete duplicate records from staging table --
1076: DELETE ddr_s_rtl_ship_item
1077: WHERE CURRENT OF c1;
1078:
1079: END LOOP; --}
1080: