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_ALTERNATES_V

Object Details

Object Name:	AHL_UNIT_ALTERNATES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_UNIT_ALTERNATES_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
CSI_ITEM_INSTANCE_ID	NUMBER		Yes	Install Base instance identifier
CSI_INSTANCE_NUMBER	VARCHAR2	(30)	Yes	Functional, user key to the CSI item instance.
CSI_OBJECT_VERSION_NUMBER	NUMBER		Yes	OBJECT_VERSION_NUMBER of Install Base instance
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier for the instance. FK to MTL_SYSTEM_ITEMS_B. This along with INVENTORY_ORG_ID identifies the unique item definition in Inventory item master
INVENTORY_ORG_ID	NUMBER		Yes	Inventory organization identifier for the instance. This is the inventory Master organization used for validating the item definition in item master.
UOM_CODE	VARCHAR2	(3)	Yes	UOM for the quantity
QUANTITY	NUMBER		Yes	Quantity of the item instance
OWNER_ID	NUMBER		Yes	Unit Configuration owner identifier. It is either PARTY_ID from HZ_PARTIES or VENDOR_ID from PO_VENDORS
OWNER_NUMBER	VARCHAR2	(30)		It is either PARTY_NUMBER from HZ_PARTIES or SEGMENT1 from PO_VENDORS
OWNER_NAME	VARCHAR2	(360)		Unit Configuration owner name. It is either PARTY_NAME from HZ_PARTIES or VENDOR_NAME from PO_VENDORS
PARTY_TYPE	VARCHAR2	(6)		It's value is either PARTY or VENDOR and is used to represent the source table to which the owner belongs to
CSI_PARTY_OBJECT_VERSION_NUM	NUMBER		Yes	OBJECT_VERSION_NUMBER for Install Base party instance record
RELATIONSHIP_ID	NUMBER		Yes	Master Configuration node identifier
PRIORITY	NUMBER	(15)	Yes	Priority for the Item as defined in alternate items for Master Configuration
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 an FK to MTL_SERIAL_NUMBERS, but is still a 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
INVENTORY_REVISION	VARCHAR2	(3)		Item instance revision from Inventory. If an item is defined as being under revision control, this would contain the revision of the instance, as manufactured or maintained. FK to MRL_ITEM_REVISIONS
INSTALL_DATE	DATE			Installation Date
CSI_LOCATION_ID	NUMBER			Item instance location identifier. FK to HZ_LOCATIONS or HR_LOCATIONS or PO_VENDOR_SITES depending on the value in LOCATION_TYPE_CODE
OWNER_SITE_NUMBER	VARCHAR2	(4000)		Owner Site Number
CSI_LOCATION_TYPE_CODE	VARCHAR2	(30)		Location type code from Install Base for the item instance. Indicates if the location_id is a FK to HR_LOCATIONS or HZ_LOCATIONS or PO_VENDOR_SITES ( until HR_LOCATIONS and PO_VENDOR_SITES merge into HZ_LOCATIONS )
LOCATION_DESCRIPTION	VARCHAR2	(4000)		Location description
STATUS	VARCHAR2	(80)		Status of the alternate item
ITEM_NUMBER	VARCHAR2	(40)		Item number from Inventory
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description from Inventory
MFG_DATE	DATE			Manufacturing date for the item instance
CONDITION	VARCHAR2	(240)		Condition of the item from Inventory
ORGANIZATION_CODE	VARCHAR2	(3)		Inventory Organization Code.

Query Text

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


SELECT CSI_ITEM_INSTANCE_ID
,      CSI_INSTANCE_NUMBER
,      CSI_OBJECT_VERSION_NUMBER
,      INVENTORY_ITEM_ID
,      INVENTORY_ORG_ID
,      UOM_CODE
,      QUANTITY
,      OWNER_ID
,      OWNER_NUMBER
,      OWNER_NAME
,      PARTY_TYPE
,      CSI_PARTY_OBJECT_VERSION_NUM
,      RELATIONSHIP_ID
,      PRIORITY
,      SERIAL_NUMBER
,      INVENTORY_REVISION
,      INSTALL_DATE
,      CSI_LOCATION_ID
,      OWNER_SITE_NUMBER
,      CSI_LOCATION_TYPE_CODE
,      LOCATION_DESCRIPTION
,      STATUS
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      MFG_DATE
,      CONDITION
,      ORGANIZATION_CODE
FROM APPS.AHL_UNIT_ALTERNATES_V;

Dependencies

[top of page]

APPS.AHL_UNIT_ALTERNATES_V references the following:

APPS: AHL_ITEM_ASSOCIATIONS_B; AHL_MC_RELATIONSHIPS; AHL_UTIL_UC_PKG - show dependent code; CSI_II_RELATIONSHIPS; CSI_INST_EXTEND_ATTRIB_V; CSI_ITEM_INSTANCES; CSI_I_PARTIES; CSI_LOOKUPS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; HZ_PARTIES; MO_GLOBAL - show dependent code; MTL_MATERIAL_STATUSES; MTL_SYSTEM_ITEMS_KFV; ORG_ORGANIZATION_DEFINITIONS; PO_VENDORS
PUBLIC: DUAL

APPS.AHL_UNIT_ALTERNATES_V is not referenced by any database object