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


VIEW: APPS.AHL_SERIAL_NUMBER_CHANGE_V

Object Details
Object Name: AHL_SERIAL_NUMBER_CHANGE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_SERIAL_NUMBER_CHANGE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.AHL_SERIAL_NUMBER_CHANGE_V references the following:

SchemaAPPS
SynonymAHL_OSP_ORDERS_B
SynonymAHL_OSP_ORDER_LINES
SynonymAHL_WORKORDERS
SynonymCSI_IEA_VALUES
SynonymCSI_IEA_VALUES_H
SynonymCSI_ITEM_INSTANCES
SynonymCSI_ITEM_INSTANCES_H
SynonymCSI_TRANSACTIONS
SynonymCSI_TXN_TYPES
ViewFND_LOOKUP_VALUES_VL
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.AHL_SERIAL_NUMBER_CHANGE_V is not referenced by any database object