[Home] [Help] [Dependency Information]
Object Name: | AHL_SERIAL_NUMBER_CHANGE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_SERIAL_NUMBER_CHANGE_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_ID | NUMBER | Yes | Identifier for instance id | |
INSTANCE_NUMBER | VARCHAR2 | (30) | Yes | Identifier for instance number |
MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | Identifier for mfg serial number flag | |
TRANSACTION_ID | NUMBER | Yes | Identifier for transaction id | |
OLD_SERIAL_NUMBER | VARCHAR2 | (30) | Identifier for old serial number value | |
NEW_SERIAL_NUMBER | VARCHAR2 | (30) | Identifier for new serial number value | |
OLD_ATTRIBUTE_VALUE | VARCHAR2 | (240) | Identifier for old attribute value | |
OLD_ATTRIBUTE_MEAN | VARCHAR2 | (80) | Identifier for old attribute mean | |
NEW_ATTRIBUTE_VALUE | VARCHAR2 | (240) | Identifier for new attribute value | |
NEW_ATTRIBUTE_MEAN | VARCHAR2 | (80) | Identifier for new attribute mean | |
LAST_UPDATE_DATE | DATE | Yes | Identifier for last transaction date | |
OLD_ITEM_NUMBER | VARCHAR2 | (40) | ||
NEW_ITEM_NUMBER | VARCHAR2 | (40) | ||
OBJECT_TYPE | VARCHAR2 | (9) | ||
OBJECT_NUM | VARCHAR2 | (80) | ||
OLD_INVENTORY_ITEM_ID | NUMBER | |||
NEW_INVENTORY_ITEM_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_ID
, INSTANCE_NUMBER
, MFG_SERIAL_NUMBER_FLAG
, TRANSACTION_ID
, OLD_SERIAL_NUMBER
, NEW_SERIAL_NUMBER
, OLD_ATTRIBUTE_VALUE
, OLD_ATTRIBUTE_MEAN
, NEW_ATTRIBUTE_VALUE
, NEW_ATTRIBUTE_MEAN
, LAST_UPDATE_DATE
, OLD_ITEM_NUMBER
, NEW_ITEM_NUMBER
, OBJECT_TYPE
, OBJECT_NUM
, OLD_INVENTORY_ITEM_ID
, NEW_INVENTORY_ITEM_ID
FROM APPS.AHL_SERIAL_NUMBER_CHANGE_V;
APPS.AHL_SERIAL_NUMBER_CHANGE_V is not referenced by any database object
|
|
|