APPS.DDR_BASE_UTIL_PKG dependencies on DDR_S_RTL_SL_RTN_ITEM

Line 683: FROM ddr_s_rtl_sl_rtn_item

679: v_FUNC_MSG VARCHAR2(1) := 'N';
680:
681: CURSOR c1 IS
682: SELECT *
683: FROM ddr_s_rtl_sl_rtn_item
684: WHERE (day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id)
685: IN (SELECT day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
686: FROM ddr_s_rtl_sl_rtn_item
687: GROUP BY day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id

Line 686: FROM ddr_s_rtl_sl_rtn_item

682: SELECT *
683: FROM ddr_s_rtl_sl_rtn_item
684: WHERE (day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id)
685: IN (SELECT day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
686: FROM ddr_s_rtl_sl_rtn_item
687: GROUP BY day_cd,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
688: HAVING count(*) > 1)
689: FOR UPDATE;
690: BEGIN

Line 792: DELETE ddr_s_rtl_sl_rtn_item

788: ,'Duplicate record - Staging'
789: );
790:
791: -- delete duplicate records from staging table --
792: DELETE ddr_s_rtl_sl_rtn_item
793: WHERE CURRENT OF c1;
794:
795: END LOOP; --}
796: