[Home] [Help] [Dependency Information]
Object Name: | MTL_OBJECT_GENEALOGY_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_OBJECT_GENEALOGY_INTERFACE |
Subobject Name: | |
Status: | VALID |
Interface table for Asset Number Genealogy Import. Asset Number Genealogy Import cuncurrent program processes rows in the table and imports asset hierarchy into Oracle Applications.
This table is used to populate data before executing EAM_AST_GEN_INTERFACE concurrent program.
Scope: public
Product: EAM
Lifecycle: active
Display Name: MTL_OBJECT_GENEALOGY_INTERFACE
Category: OPEN_INTERFACE EAM_AST_GEN_INTERFACE 1
Category: BUSINESS_ENTITY EAM_ASSET_NUMBER
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_OBJECT_GEN_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_HEADER_ID |
MTL_OBJECT_GEN_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (38) | Yes | Batch identifier |
INTERFACE_HEADER_ID | NUMBER | (38) | Yes | Interface Header identifier |
GROUP_ID | NUMBER | (38) | Group identifier | |
OBJECT_ID | NUMBER | (38) | Genealogy object identifier | |
OBJECT_TYPE | NUMBER | (38) | Yes | Genealogy object type |
PARENT_OBJECT_TYPE | NUMBER | (38) | Yes | Genealogy object type of parent |
PARENT_OBJECT_ID | NUMBER | (38) | Parent object identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Columns | |
LAST_UPDATED_BY | NUMBER | (38) | Yes | Standard WHO Columns |
CREATION_DATE | DATE | Yes | Standard WHO Columns | |
CREATED_BY | NUMBER | (38) | Yes | Standard WHO Columns |
START_DATE_ACTIVE | DATE | Start Date Active | ||
END_DATE_ACTIVE | DATE | End Date Active | ||
GENEALOGY_ORIGIN | NUMBER | (38) | Yes | Origin to establish the genealogy |
ORIGIN_TXN_ID | NUMBER | (38) | Origin Transaction identifier | |
GENEALOGY_TYPE | NUMBER | (38) | Yes | Genealogy type |
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard WHO Columns | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment | |
REQUEST_ID | NUMBER | (38) | Standard WHO Columns | |
PROGRAM_APPLICATION_ID | NUMBER | (38) | Standard WHO Columns | |
PROGRAM_ID | NUMBER | (38) | Standard WHO Columns | |
PROGRAM_UPDATE_DATE | DATE | Standard WHO Columns | ||
UPDATE_TXN_ID | NUMBER | (38) | Update Transaction Identifier | |
INVENTORY_ITEM_ID | NUMBER | (38) | Yes | Item identifier |
SERIAL_NUMBER | VARCHAR2 | (30) | Yes | Serial Number identifier |
ORGANIZATION_CODE | VARCHAR2 | (3) | Yes | Organization code |
ORGANIZATION_ID | NUMBER | (38) | Organization identifier | |
PARENT_INVENTORY_ITEM_ID | NUMBER | (38) | Yes | Parent Item identifier |
PARENT_SERIAL_NUMBER | VARCHAR2 | (30) | Yes | Parent Serial Number identifier |
PARENT_ORGANIZATION_CODE | VARCHAR2 | (3) | Yes | Parent organization code |
PROCESS_STATUS | VARCHAR2 | (1) | Yes | Process status |
ERROR_MESSAGE | VARCHAR2 | (240) | Error message | |
ERROR_CODE | NUMBER | (38) | Error code | |
IMPORT_MODE | NUMBER | Yes | Import mode | |
PARENT_ORGANIZATION_ID | NUMBER | (38) | Parent Organization identifier | |
RETURN_TO_INVENTORY | VARCHAR2 | (1) | Return to Inventory flag | |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Subinventory Code | |
LOCATOR_ID | NUMBER | Locator Id |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, INTERFACE_HEADER_ID
, GROUP_ID
, OBJECT_ID
, OBJECT_TYPE
, PARENT_OBJECT_TYPE
, PARENT_OBJECT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, GENEALOGY_ORIGIN
, ORIGIN_TXN_ID
, GENEALOGY_TYPE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, UPDATE_TXN_ID
, INVENTORY_ITEM_ID
, SERIAL_NUMBER
, ORGANIZATION_CODE
, ORGANIZATION_ID
, PARENT_INVENTORY_ITEM_ID
, PARENT_SERIAL_NUMBER
, PARENT_ORGANIZATION_CODE
, PROCESS_STATUS
, ERROR_MESSAGE
, ERROR_CODE
, IMPORT_MODE
, PARENT_ORGANIZATION_ID
, RETURN_TO_INVENTORY
, SUBINVENTORY_CODE
, LOCATOR_ID
FROM INV.MTL_OBJECT_GENEALOGY_INTERFACE;
INV.MTL_OBJECT_GENEALOGY_INTERFACE does not reference any database object
INV.MTL_OBJECT_GENEALOGY_INTERFACE is referenced by following:
|
|
|