Previous | Next | Contents | Index | Glossary | Library |
Attention: Note that deleted items are not archived.
You can check for references to an item before deleting it. You can also check for references without having to delete the item.
See: Creating Custom Delete Constraints.
Delete Constraint | Conditions checked |
---|---|
ITM_CON1 | Open demand or reservations in MTL_DEMAND |
ITM_CON2 | Potential demand or reservations in MTL_DEMAND_INTERFACE |
ITM_CON3 | Transaction history in MTL_MATERIAL_TRANSACTIONS |
ITM_CON4 | Pending transactions in MTL_MATERIAL_TRANSACTIONS_TEMP |
ITM_CON5 | On-hand balances in MTL_ONHAND_QUANTITIES |
ITM_CON6 | Physical inventory history in MTL_PHYSICAL_ADJUSTMENTS |
ITM_CON7 | Physical inventory tags in MTL_PHYSICAL_INVENTORY_TAGS |
ITM_CON8 | Replenishment counts in MTL_REPLENISH_LINES |
ITM_CON9 | Potential replenishment counts in MTL_REPLENISH_LINES_INT |
ITM_CON10 | Return authorizations in MTL_SO_RMA_INTERFACE |
ITM_CON11 | Uncounted cycle count requests for the item in MTL_CYCLE_COUNT_ENTRIES with status_code > 1 |
ITM_CON12 | Planned receipts and intransit quantities in MTL_SUPPLY |
ITM_CON13 | Pending transactions in MTL_TRANSACTIONS_INTERFACE |
ITM_CON14 | A bill of materials for the item in BOM_BILL_OF_MATERIALS |
ITM_CON15 | The item is a component on a bill in BOM_INVENTORY_COMPONENTS |
ITM_CON16 | A routing exists in BOM_OPERATIONAL_ROUTINGS |
ITM_CON17 | The item is a substitute component for a bill in BOM_SUBSTITUTE_COMPONENTS |
ITM_CON18 | Any forecasts containing the item in MRP_FORECAST_ITEMS |
ITM_CON19 | Master schedules containing the item in MRP_SCHEDULE_ITEMS |
ITM_CON20 | A copy of an MRP planned item in MRP_SYSTEM_ITEMS |
ITM_CON21 | The item appears as a revised component in ENG_REVISED_COMPONENTS |
ITM_CON22 | The item appears as a revised item or a use up item on an engineering change order (ECO) in ENG_REVISED_ITEMS |
ITM_CON23 | Discrete jobs or repetitive schedules for the item (assembly) in WIP_ENTITIES |
ITM_CON24 | Discrete jobs or repetitive schedules that require the item in WIP_REQUIREMENT_OPERATIONS |
ITM_CON25 | 'Blanket' or 'contract' Purchase Orders for the item in PO_LINES and PO_HEADERS |
ITM_CON26 | Shipments of the item in RCV_SHIPMENT_LINES |
ITM_CON27 | Requisitions for the item in PO_REQUISITION_LINES |
ITM_CON28 | Potential requisitions for the item in PO_REQUISITIONS_INTERFACE |
ITM_CON29 | Any ReqExpress template lines for the item in PO_REQEXPRESS_LINES |
ITM_CON30 | An autosource rule for the item exists in PO_AUTOSOURCE_RULES |
ITM_CON31 | Any PO lines for the item with a ship-to location in the current organization in PO_LINES and PO_LINE_LOCATIONS |
ITM_CON32 | Receiving transactions for the item in RCV_TRANSACTIONS_INTERFACE |
ITM_CON33 | Any discrete jobs to build the item in WIP_DISCRETE_JOBS |
ITM_CON34 | Any potential discrete jobs or repetitive schedules for the item to be loaded into Oracle Work in Process in WIP_JOB_SCHEDULE_INTERFACE |
ITM_CON35 | The item is identified as a purchased item resource in BOM_RESOURCES |
ITM_CON36 | No invoices, or credit memo or commitment line transactions exist in RA_CUSTOMER_TRX_LINES |
ITM_CON37 | Cost update adjustment details for the item in CST_STD_COST_ADJ_VALUES |
ITM_CON38 | Cost rollup and cost type purge information in CST_COST_TYPE_HISTORY |
ITM_CON39 | The item in any ABC compile in MTL_ABC_COMPILES |
ITM_CON40 | The item in any ABC class assignments in MTL_ABC_ASSIGNMENTS |
ITM_CON41 | Any demand for the item in MTL_USER_DEMAND |
ITM_CON42 | Any supply for the item in MTL_USER_SUPPLY |
ITM_CON43 | The item is included in a bill of resource set in CRP_BILL_OF_RESOURCE_ITEMS |
ITM_CON44 | Sales order lines for the item exist in SO_LINES |
ITM_CON45 | Sales order line details exist for the item in SO_LINE_DETAILS |
ITM_CON46 | Picking lines exist in SO_PICKING_LINES |
ITM_CON47 | Any upgrade history for the item in CST_STANDARD_COSTS |
ITM_CON48 | Items in the master organization existing in a child organization where the item fails delete constraints for that child organization |
ITM_CON49 | Pull sequence exists for this item (MTL_KANBAN_PULL_SEQUENCES) |
ITM_CON50 | Kanban cards exist for this item (MTL_KANBAN_CARDS) |
Previous | Next | Contents | Index | Glossary | Library |