APPS.WIP_WICTPG dependencies on WIP_LPN_COMPLETIONS_LOTS

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 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