APPS.WIP_WICTPG dependencies on MTL_SUPPLY_DEMAND_TEMP

Line 1803: x_purge_rec.table_name := 'MTL_SUPPLY_DEMAND_TEMP';

1799: --Fix for Bug#4716115 ENDS
1800: --
1801:
1802:
1803: x_purge_rec.table_name := 'MTL_SUPPLY_DEMAND_TEMP';
1804:
1805: if (p_option = REPORT_ONLY) then
1806: SELECT COUNT(*) INTO x_num_rows
1807: FROM MTL_SUPPLY_DEMAND_TEMP

Line 1807: FROM MTL_SUPPLY_DEMAND_TEMP

1803: x_purge_rec.table_name := 'MTL_SUPPLY_DEMAND_TEMP';
1804:
1805: if (p_option = REPORT_ONLY) then
1806: SELECT COUNT(*) INTO x_num_rows
1807: FROM MTL_SUPPLY_DEMAND_TEMP
1808: WHERE DISPOSITION_TYPE = 5
1809: AND DISPOSITION_ID = x_purge_rec.wip_entity_id;
1810: else
1811: DELETE FROM MTL_SUPPLY_DEMAND_TEMP

Line 1811: DELETE FROM MTL_SUPPLY_DEMAND_TEMP

1807: FROM MTL_SUPPLY_DEMAND_TEMP
1808: WHERE DISPOSITION_TYPE = 5
1809: AND DISPOSITION_ID = x_purge_rec.wip_entity_id;
1810: else
1811: DELETE FROM MTL_SUPPLY_DEMAND_TEMP
1812: WHERE DISPOSITION_TYPE = 5
1813: AND DISPOSITION_ID = x_purge_rec.wip_entity_id;
1814: x_num_rows := SQL%ROWCOUNT ;
1815: end if;