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_UNIT_DETAILS_V

Object Details

Object Name:	AHL_UNIT_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_UNIT_DETAILS_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	Comments
RELATIONSHIP_ID	NUMBER		Master Configuration node identifier
CSI_ITEM_INSTANCE_ID	NUMBER		Install Base instance identifier
CSI_OBJECT_VERSION	NUMBER		OBJECT_VERSION_NUMBER of Install Base instance
POSITION_REF_MEANING	VARCHAR2	(80)	Master Configuration node's position meaning
POSITION_NECESSITY_MEANING	VARCHAR2	(80)	Position's Necessity Meaning from Master Configuration.
QUANTITY	NUMBER		Quantity of item installed
UOM_CODE	VARCHAR2	(3)	UOM for the quantity
CSI_II_RELATIONSHIP_ID	NUMBER		Relationship identifier from Install Base if item instance has a parent
CSI_II_OBJECT_VERSION	NUMBER		Install Base Relationship identifier's object version
PARENT_CSI_INSTANCE_ID	NUMBER		Parent instance identifier if the item instance has a parent
DESCRIPTION	VARCHAR2	(2000)	Master Configuration position description
PARENT_RELATIONSHIP_ID	NUMBER		Parent node identifier
SERIAL_NUMBER	VARCHAR2	(30)	Serial number of the item instance if the item is serialized. FK to MTL_SERIAL_NUMBERS if the item is under serial control and the MFG_SERIAL_NUMBER_FLAG is set to 'Y'. If it's set to 'N' then it is not a FK to MTL_SERIAL_NUMBERS, but is still an unique identifier to a serialized item instance. The item should be defined as serial controlled in item master to have any value in this column
REVISION	VARCHAR2	(3)	FK to MRL_ITEM_REVISIONS. If an item is defined as being under revision control, this would contain the revision of the instance, as manufactured or maintained
LOT_NUMBER	VARCHAR2	(80)	Lot number of the item instance if item is under lot control
ITEM_NUMBER	VARCHAR2	(40)	Item number from Inventory
MFG_DATE	DATE		Manufacturing date for the item instance

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RELATIONSHIP_ID
,      CSI_ITEM_INSTANCE_ID
,      CSI_OBJECT_VERSION
,      POSITION_REF_MEANING
,      POSITION_NECESSITY_MEANING
,      QUANTITY
,      UOM_CODE
,      CSI_II_RELATIONSHIP_ID
,      CSI_II_OBJECT_VERSION
,      PARENT_CSI_INSTANCE_ID
,      DESCRIPTION
,      PARENT_RELATIONSHIP_ID
,      SERIAL_NUMBER
,      REVISION
,      LOT_NUMBER
,      ITEM_NUMBER
,      MFG_DATE
FROM APPS.AHL_UNIT_DETAILS_V;

Dependencies

[top of page]

APPS.AHL_UNIT_DETAILS_V references the following:

APPS: AHL_MC_HEADERS_VL; AHL_MC_RELATIONSHIPS; AHL_UNIT_CONFIG_HEADERS; CSI_II_RELATIONSHIPS; CSI_INST_EXTEND_ATTRIB_V; CSI_ITEM_INSTANCES; FND_GLOBAL - show dependent code; FND_LOOKUPS; MTL_SYSTEM_ITEMS_KFV

APPS.AHL_UNIT_DETAILS_V is not referenced by any database object