APPS.WIP_WICTPG dependencies on MTL_DEMAND_INTERFACE

Line 1587: x_purge_rec.table_name := 'MTL_DEMAND_INTERFACE';

1583: p_purge_rec => x_purge_rec,
1584: num_rows => x_num_rows);
1585: end if;
1586:
1587: x_purge_rec.table_name := 'MTL_DEMAND_INTERFACE';
1588:
1589: if (p_option = REPORT_ONLY) then
1590: SELECT COUNT(*) INTO x_num_rows
1591: FROM MTL_DEMAND_INTERFACE

Line 1591: FROM MTL_DEMAND_INTERFACE

1587: x_purge_rec.table_name := 'MTL_DEMAND_INTERFACE';
1588:
1589: if (p_option = REPORT_ONLY) then
1590: SELECT COUNT(*) INTO x_num_rows
1591: FROM MTL_DEMAND_INTERFACE
1592: WHERE ORGANIZATION_ID = x_purge_rec.org_id
1593: AND SUPPLY_SOURCE_TYPE = 5
1594: AND SUPPLY_HEADER_ID = x_purge_rec.wip_entity_id;
1595: else

Line 1596: DELETE FROM MTL_DEMAND_INTERFACE

1592: WHERE ORGANIZATION_ID = x_purge_rec.org_id
1593: AND SUPPLY_SOURCE_TYPE = 5
1594: AND SUPPLY_HEADER_ID = x_purge_rec.wip_entity_id;
1595: else
1596: DELETE FROM MTL_DEMAND_INTERFACE
1597: WHERE ORGANIZATION_ID = x_purge_rec.org_id
1598: AND SUPPLY_SOURCE_TYPE = 5
1599: AND SUPPLY_HEADER_ID = x_purge_rec.wip_entity_id;
1600: