[Home] [Help] [Dependency Information]
Object Name: | MTL_CONSIGNED_DIAG_ERRORS |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_CONSIGNED_DIAG_ERRORS |
Subobject Name: | |
Status: | VALID |
This table contains the results of the Consigned inventory diagnostics concurrent program.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_CONSIGNED_DIAG_ERRORS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
REVISION OWNING_ORGANIZATION_ID ORGANIZATION_ID ERROR_CODE RECORD_TYPE PO_HEADER_ID |
MTL_CONSIGNED_DIAG_ERRORS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CONSUMPTION_DATE |
MTL_CONSIGNED_DIAG_ERRORS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OWNING_ORGANIZATION_ID |
MTL_CONSIGNED_DIAG_ERRORS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | AGENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_ID | NUMBER | Yes | Sequence generated record identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
REVISION | VARCHAR2 | (3) | Inventory item revision | |
OWNING_TP_TYPE | NUMBER | Owning trading partner type | ||
OWNING_ORGANIZATION_ID | NUMBER | Yes | Owning organization identifier | |
PLANNING_TP_TYPE | NUMBER | Planning trading partner type | ||
PLANNING_ORGANIZATION_ID | NUMBER | Planning organization identifier | ||
PO_HEADER_ID | NUMBER | Source PO document associated with the consumption transaction. | ||
AGENT_ID | NUMBER | Buyer identifier | ||
RECORD_TYPE | NUMBER | Yes | Diagnostics error record type. Values 1: Indicates a validation error at the time of consumption, 2: Indicates a validation error at the time of consumption advice generation. | |
ERROR_CODE | VARCHAR2 | (30) | Yes | Error message name |
ERROR_TYPE | NUMBER | Yes | Error type. Values 1: Blanket agreement, 2: Exchange rate, 3: Manual numbering, 4: Other errors | |
ACTION_CODE | VARCHAR2 | (30) | Action message name | |
PURCHASING_UOM | VARCHAR2 | (30) | This column contains the purchasing unit of measure code. This column will be populated only if the error code is related to UOM conversion issues. | |
PRIMARY_UOM | VARCHAR2 | (30) | This column contains the primary unit of measure code. This column will be populated only if the error code is related to UOM conversion issues. | |
LAST_NOTIFICATION_DATE | DATE | Date the notification was last sent for this error record | ||
NOTIFICATION_ID | NUMBER | Notification identifier | ||
CONSUMPTION_DATE | DATE | Consumption transaction date. | ||
CREATION_DATE | DATE | Yes | who column | |
CREATED_BY | NUMBER | Yes | who column | |
LAST_UPDATE_DATE | DATE | Yes | who column | |
LAST_UPDATED_BY | NUMBER | Yes | who column | |
LAST_UPDATE_LOGIN | NUMBER | who column | ||
REQUEST_ID | NUMBER | Request id | ||
PROGRAM_APPLICATION_ID | NUMBER | who column | ||
PROGRAM_ID | NUMBER | who column | ||
PROGRAM_UPDATE_DATE | DATE | who column |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, REVISION
, OWNING_TP_TYPE
, OWNING_ORGANIZATION_ID
, PLANNING_TP_TYPE
, PLANNING_ORGANIZATION_ID
, PO_HEADER_ID
, AGENT_ID
, RECORD_TYPE
, ERROR_CODE
, ERROR_TYPE
, ACTION_CODE
, PURCHASING_UOM
, PRIMARY_UOM
, LAST_NOTIFICATION_DATE
, NOTIFICATION_ID
, CONSUMPTION_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM INV.MTL_CONSIGNED_DIAG_ERRORS;
INV.MTL_CONSIGNED_DIAG_ERRORS does not reference any database object
INV.MTL_CONSIGNED_DIAG_ERRORS is referenced by following:
|
|
|