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.WIP_WICTPG dependencies on WIP_LPN_COMPLETIONS

Line 1714: --Purge records from WIP_LPN_COMPLETIONS, WIP_LPN_COMPLETIONS_LOTS, WIP_LPN_COMPLETIONS_SERIALS

1710:
1711:
1712: --
1713: --Bug#4716115 START
1714: --Purge records from WIP_LPN_COMPLETIONS, WIP_LPN_COMPLETIONS_LOTS, WIP_LPN_COMPLETIONS_SERIALS
1715: --
1716:
1717: -- delete from wip_lpn_completions_lots
1718: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_LOTS';

Line 1717: -- delete from wip_lpn_completions_lots

1713: --Bug#4716115 START
1714: --Purge records from WIP_LPN_COMPLETIONS, WIP_LPN_COMPLETIONS_LOTS, WIP_LPN_COMPLETIONS_SERIALS
1715: --
1716:
1717: -- delete from wip_lpn_completions_lots
1718: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_LOTS';
1719:
1720: if (p_option = REPORT_ONLY) then
1721: SELECT COUNT(*) INTO X_NUM_ROWS

Line 1718: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_LOTS';

1714: --Purge records from WIP_LPN_COMPLETIONS, WIP_LPN_COMPLETIONS_LOTS, WIP_LPN_COMPLETIONS_SERIALS
1715: --
1716:
1717: -- delete from wip_lpn_completions_lots
1718: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_LOTS';
1719:
1720: if (p_option = REPORT_ONLY) then
1721: SELECT COUNT(*) INTO X_NUM_ROWS
1722: FROM WIP_LPN_COMPLETIONS_LOTS WLCL

Line 1722: FROM WIP_LPN_COMPLETIONS_LOTS WLCL

1718: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_LOTS';
1719:
1720: if (p_option = REPORT_ONLY) then
1721: SELECT COUNT(*) INTO X_NUM_ROWS
1722: FROM WIP_LPN_COMPLETIONS_LOTS WLCL
1723: WHERE WLCL.HEADER_ID IN
1724: (
1725: SELECT WLC.HEADER_ID
1726: FROM WIP_LPN_COMPLETIONS WLC

Line 1726: FROM WIP_LPN_COMPLETIONS WLC

1722: FROM WIP_LPN_COMPLETIONS_LOTS WLCL
1723: WHERE WLCL.HEADER_ID IN
1724: (
1725: SELECT WLC.HEADER_ID
1726: FROM WIP_LPN_COMPLETIONS WLC
1727: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID
1728: );
1729: else
1730: DELETE FROM WIP_LPN_COMPLETIONS_LOTS WLCL

Line 1730: DELETE FROM WIP_LPN_COMPLETIONS_LOTS WLCL

1726: FROM WIP_LPN_COMPLETIONS WLC
1727: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID
1728: );
1729: else
1730: DELETE FROM WIP_LPN_COMPLETIONS_LOTS WLCL
1731: WHERE WLCL.HEADER_ID IN
1732: (
1733: SELECT WLC.HEADER_ID
1734: FROM WIP_LPN_COMPLETIONS WLC

Line 1734: FROM WIP_LPN_COMPLETIONS WLC

1730: DELETE FROM WIP_LPN_COMPLETIONS_LOTS WLCL
1731: WHERE WLCL.HEADER_ID IN
1732: (
1733: SELECT WLC.HEADER_ID
1734: FROM WIP_LPN_COMPLETIONS WLC
1735: WHERE WLC.TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID
1736: );
1737: x_num_rows := SQL%ROWCOUNT ;
1738: end if;

Line 1747: -- delete from wip_lpn_completions_serials

1743: p_purge_rec => x_purge_rec,
1744: num_rows => x_num_rows);
1745: end if;
1746:
1747: -- delete from wip_lpn_completions_serials
1748: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_SERIALS';
1749:
1750: if (p_option = REPORT_ONLY) then
1751: SELECT COUNT(*) INTO X_NUM_ROWS

Line 1748: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_SERIALS';

1744: num_rows => x_num_rows);
1745: end if;
1746:
1747: -- delete from wip_lpn_completions_serials
1748: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_SERIALS';
1749:
1750: if (p_option = REPORT_ONLY) then
1751: SELECT COUNT(*) INTO X_NUM_ROWS
1752: FROM WIP_LPN_COMPLETIONS_SERIALS WLCS

Line 1752: FROM WIP_LPN_COMPLETIONS_SERIALS WLCS

1748: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS_SERIALS';
1749:
1750: if (p_option = REPORT_ONLY) then
1751: SELECT COUNT(*) INTO X_NUM_ROWS
1752: FROM WIP_LPN_COMPLETIONS_SERIALS WLCS
1753: WHERE WLCS.HEADER_ID IN
1754: (
1755: SELECT WLC.HEADER_ID
1756: FROM WIP_LPN_COMPLETIONS WLC

Line 1756: FROM WIP_LPN_COMPLETIONS WLC

1752: FROM WIP_LPN_COMPLETIONS_SERIALS WLCS
1753: WHERE WLCS.HEADER_ID IN
1754: (
1755: SELECT WLC.HEADER_ID
1756: FROM WIP_LPN_COMPLETIONS WLC
1757: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID
1758: );
1759: else
1760: DELETE FROM WIP_LPN_COMPLETIONS_SERIALS WLCS

Line 1760: DELETE FROM WIP_LPN_COMPLETIONS_SERIALS WLCS

1756: FROM WIP_LPN_COMPLETIONS WLC
1757: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID
1758: );
1759: else
1760: DELETE FROM WIP_LPN_COMPLETIONS_SERIALS WLCS
1761: WHERE WLCS.HEADER_ID IN
1762: (
1763: SELECT WLC.HEADER_ID
1764: FROM WIP_LPN_COMPLETIONS WLC

Line 1764: FROM WIP_LPN_COMPLETIONS WLC

1760: DELETE FROM WIP_LPN_COMPLETIONS_SERIALS WLCS
1761: WHERE WLCS.HEADER_ID IN
1762: (
1763: SELECT WLC.HEADER_ID
1764: FROM WIP_LPN_COMPLETIONS WLC
1765: WHERE WLC.TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID
1766: );
1767: x_num_rows := SQL%ROWCOUNT ;
1768: end if;

Line 1778: -- delete from wip_lpn_completions

1774: num_rows => x_num_rows);
1775: end if;
1776:
1777:
1778: -- delete from wip_lpn_completions
1779: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS';
1780:
1781: if (p_option = REPORT_ONLY) then
1782: SELECT COUNT(*) INTO X_NUM_ROWS

Line 1779: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS';

1775: end if;
1776:
1777:
1778: -- delete from wip_lpn_completions
1779: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS';
1780:
1781: if (p_option = REPORT_ONLY) then
1782: SELECT COUNT(*) INTO X_NUM_ROWS
1783: FROM WIP_LPN_COMPLETIONS

Line 1783: FROM WIP_LPN_COMPLETIONS

1779: x_purge_rec.table_name := 'WIP_LPN_COMPLETIONS';
1780:
1781: if (p_option = REPORT_ONLY) then
1782: SELECT COUNT(*) INTO X_NUM_ROWS
1783: FROM WIP_LPN_COMPLETIONS
1784: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID;
1785: else
1786: DELETE FROM WIP_LPN_COMPLETIONS
1787: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID;

Line 1786: DELETE FROM WIP_LPN_COMPLETIONS

1782: SELECT COUNT(*) INTO X_NUM_ROWS
1783: FROM WIP_LPN_COMPLETIONS
1784: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID;
1785: else
1786: DELETE FROM WIP_LPN_COMPLETIONS
1787: WHERE TRANSACTION_SOURCE_ID = X_PURGE_REC.WIP_ENTITY_ID;
1788: x_num_rows := SQL%ROWCOUNT ;
1789: end if;
1790: