APPS.WIP_WICTPG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1635: x_purge_rec.table_name := 'MTL_MATERIAL_TRANSACTIONS_TEMP';

1631: num_rows => x_num_rows);
1632: end if;
1633:
1634:
1635: x_purge_rec.table_name := 'MTL_MATERIAL_TRANSACTIONS_TEMP';
1636:
1637: if (x_purge_rec.primary_item_id IS NULL) then
1638: if (p_option = REPORT_ONLY) then
1639: SELECT COUNT(*)

Line 1641: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1637: if (x_purge_rec.primary_item_id IS NULL) then
1638: if (p_option = REPORT_ONLY) then
1639: SELECT COUNT(*)
1640: INTO x_num_rows
1641: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1642: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1643: AND INVENTORY_ITEM_ID IS NULL
1644: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1645: else

Line 1646: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1642: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1643: AND INVENTORY_ITEM_ID IS NULL
1644: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1645: else
1646: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1647: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1648: AND INVENTORY_ITEM_ID IS NULL
1649: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1650:

Line 1659: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1655:
1656: if (p_option = REPORT_ONLY) then
1657: SELECT COUNT(*)
1658: INTO x_num_rows
1659: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1660: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1661: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id
1662: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1663: else

Line 1664: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1660: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1661: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id
1662: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1663: else
1664: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1665: WHERE TRANSACTION_SOURCE_TYPE_ID = 5
1666: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id
1667: AND TRANSACTION_SOURCE_ID = x_purge_rec.wip_entity_id;
1668: