[Home] [Help] [Dependency Information]
Object Name: | MTL_PURGE_HEADER |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_PURGE_HEADER |
Subobject Name: | |
Status: | VALID |
MTL_PURGE_HEADER maintains a history of transaction purges. Each
record includes a purge name, purge date, and the organization.
.
PURGE_NAME is a name entered by the user when the transaction purge is
launched. Transactions that are dated on or before PURGE_DATE will be
purged.
.
The transaction tables that are purged are:
=
MTL_MATERIAL_TRANSACTIONS
MTL_TRANSACTION_LOT_NUMBERS
MTL_UNIT_TRANSACTIONS
MTL_TRANSACTION_ACCOUNTS
MTL_MATERIAL_TXN_ALLOCATIONS
=
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_ID | NUMBER | Yes | Purge header identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
PURGE_DATE | DATE | Yes | Purge date | |
ARCHIVE_FLAG | VARCHAR2 | (1) | (not currently used) | |
PURGE_NAME | VARCHAR2 | (30) | Yes | Purge header name |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
MOVE_ORDER_TYPE | NUMBER | Move Order Type | ||
CREATION_DATE_FROM | DATE | Move Order Creation Date From | ||
CREATION_DATE_TO | DATE | Move Order Creation Date To | ||
LINES_PURGED | NUMBER | Number of Lines Purged |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, PURGE_DATE
, ARCHIVE_FLAG
, PURGE_NAME
, ORGANIZATION_ID
, MOVE_ORDER_TYPE
, CREATION_DATE_FROM
, CREATION_DATE_TO
, LINES_PURGED
FROM INV.MTL_PURGE_HEADER;
INV.MTL_PURGE_HEADER does not reference any database object
INV.MTL_PURGE_HEADER is referenced by following:
|
|
|