DBA Data[Home] [Help] [Dependency Information]

TABLE: INV.MTL_PURGE_HEADER

Object Details
Object Name: MTL_PURGE_HEADER
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.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
=


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

INV.MTL_PURGE_HEADER does not reference any database object

INV.MTL_PURGE_HEADER is referenced by following:

SchemaINV
ViewMTL_PURGE_HEADER#