eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	AHL.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)		Attribute containing Old Item Number
NEW_ITEM_NUMBER	VARCHAR2	(40)		Attribute containing New Item Number
OBJECT_TYPE	VARCHAR2	(9)		Attribute signifying the object which changed the instance. It could be either OSP Line or Workorder.
OBJECT_NUM	VARCHAR2	(80)		Unique identifier for the Object. Either Workorder Id or OSP Line Id.
OLD_INVENTORY_ITEM_ID	NUMBER			Identifier for Old Inventory Item.
NEW_INVENTORY_ITEM_ID	NUMBER			Identifier for New Inventory Item.

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:

APPS: AHL_OSP_ORDERS_B; AHL_OSP_ORDER_LINES; AHL_WORKORDERS; CSI_IEA_VALUES; CSI_IEA_VALUES_H; CSI_ITEM_INSTANCES; CSI_ITEM_INSTANCES_H; CSI_TRANSACTIONS; CSI_TXN_TYPES; FND_LOOKUP_VALUES_VL; MTL_SYSTEM_ITEMS_KFV

APPS.AHL_SERIAL_NUMBER_CHANGE_V is not referenced by any database object