eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DDR_BASE_UTIL_PKG dependencies on DDR_S_MFG_SHIP_ITEM

Line 1705: FROM ddr_s_mfg_ship_item

1701: v_FUNC_MSG VARCHAR2(1) := 'N';
1702:
1703: CURSOR c1 IS
1704: SELECT *
1705: FROM ddr_s_mfg_ship_item
1706: WHERE
1707: (day_cd,bsns_unit_id,mfg_sku_item_id,ship_to_bsns_unit_id)
1708: IN (SELECT
1709: day_cd,bsns_unit_id,mfg_sku_item_id,ship_to_bsns_unit_id

Line 1710: FROM ddr_s_mfg_ship_item

1706: WHERE
1707: (day_cd,bsns_unit_id,mfg_sku_item_id,ship_to_bsns_unit_id)
1708: IN (SELECT
1709: day_cd,bsns_unit_id,mfg_sku_item_id,ship_to_bsns_unit_id
1710: FROM ddr_s_mfg_ship_item
1711: GROUP BY
1712: day_cd,bsns_unit_id,mfg_sku_item_id,ship_to_bsns_unit_id
1713: HAVING count(*) > 1)
1714: FOR UPDATE;

Line 1777: DELETE ddr_s_mfg_ship_item

1773: ,rec.ship_cost_lcl
1774: );
1775:
1776: -- delete duplicate records from staging table --
1777: DELETE ddr_s_mfg_ship_item
1778: WHERE CURRENT OF c1;
1779:
1780: END LOOP; --}
1781: