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

VIEW: APPS.AHL_UNIT_INSTALLED_DETAILS_V

Object Details
Object Name: AHL_UNIT_INSTALLED_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_UNIT_INSTALLED_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 Mandatory Comments
CSI_ITEM_INSTANCE_ID NUMBER
Yes Install Base instance identifier
CSI_OBJECT_VERSION NUMBER
Yes OBJECT_VERSION_NUMBER of Install Base instance
CSI_INSTANCE_NUMBER VARCHAR2 (30) Yes Functional, user key to the CSI item instance.
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier for the instance
INVENTORY_ORG_ID NUMBER

Inventory organization identifier for the instance
ORGANIZATION_CODE VARCHAR2 (3)
Inventory Organization Code.
UOM_CODE VARCHAR2 (3) Yes UOM for the quantity
QUANTITY NUMBER
Yes Quantity of the item instance
SERIAL_NUMBER VARCHAR2 (30)
Serial number of the item instance if item is serialized
MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
To indicate whether the serial number is from Inventory
REVISION VARCHAR2 (3)
Revision of the item instance if item is under revision control
LOT_NUMBER VARCHAR2 (80)
Lot number to which the item belongs
INSTALL_DATE DATE

Installation Date
CSI_LOCATION_ID NUMBER

Item instance location identifier
LOCATION_DESCRIPTION VARCHAR2 (4000)
Location description
STATUS VARCHAR2 (80)
Instance usage code for the item instance
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
SERIALNUM_TAG_CODE VARCHAR2 (240)
Indicates if serial number entered is temporary, actual or from inventory. The Tag Codes are defined in FND_LOOKUPS with type='AHL_SERIALNUMBER_TAG'
SERIALNUM_TAG_MEANING VARCHAR2 (80)
Serial Number Tag Meaning.
CONDITION VARCHAR2 (240)
Condition of the item from Inventory
PARTY_TYPE VARCHAR2 (80)
It's value is either PARTY or VENDOR and is used to represent the source table to which the owner belongs to
OWNER_ID NUMBER

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
CSI_PARTY_OBJECT_VERSION_NUM NUMBER

OBJECT_VERSION_NUMBER for Install Base party instance record
OWNER_SITE_NUMBER VARCHAR2 (4000)
It is either PARTY_SITE_NUMBER from HZ_PARTY_SITES or VENDOR_SITE_CODE from PO_VENDOR_SITES_ALL
WIP_ENTITY_ID NUMBER

WIP_ENTITY_NAME VARCHAR2 (240)
CONTEXT VARCHAR2 (30)
Context for the DFF
ATTRIBUTE1 VARCHAR2 (240)
DFF segment
ATTRIBUTE2 VARCHAR2 (240)
DFF segment
ATTRIBUTE3 VARCHAR2 (240)
DFF segment
ATTRIBUTE4 VARCHAR2 (240)
DFF segment
ATTRIBUTE5 VARCHAR2 (240)
DFF segment
ATTRIBUTE6 VARCHAR2 (240)
DFF segment
ATTRIBUTE7 VARCHAR2 (240)
DFF segment
ATTRIBUTE8 VARCHAR2 (240)
DFF segment
ATTRIBUTE9 VARCHAR2 (240)
DFF segment
ATTRIBUTE10 VARCHAR2 (240)
DFF segment
ATTRIBUTE11 VARCHAR2 (240)
DFF segment
ATTRIBUTE12 VARCHAR2 (240)
DFF segment
ATTRIBUTE13 VARCHAR2 (240)
DFF segment
ATTRIBUTE14 VARCHAR2 (240)
DFF segment
ATTRIBUTE15 VARCHAR2 (240)
DFF segment
ATTRIBUTE16 VARCHAR2 (240)
DFF segment
ATTRIBUTE17 VARCHAR2 (240)
DFF segment
ATTRIBUTE18 VARCHAR2 (240)
DFF segment
ATTRIBUTE19 VARCHAR2 (240)
DFF segment
ATTRIBUTE20 VARCHAR2 (240)
DFF segment
ATTRIBUTE21 VARCHAR2 (240)
DFF segment
ATTRIBUTE22 VARCHAR2 (240)
DFF segment
ATTRIBUTE23 VARCHAR2 (240)
DFF segment
ATTRIBUTE24 VARCHAR2 (240)
DFF segment
ATTRIBUTE25 VARCHAR2 (240)
DFF segment
ATTRIBUTE26 VARCHAR2 (240)
DFF segment
ATTRIBUTE27 VARCHAR2 (240)
DFF segment
ATTRIBUTE28 VARCHAR2 (240)
DFF segment
ATTRIBUTE29 VARCHAR2 (240)
DFF segment
ATTRIBUTE30 VARCHAR2 (240)
DFF segment
Query Text

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


SELECT CSI_ITEM_INSTANCE_ID
,      CSI_OBJECT_VERSION
,      CSI_INSTANCE_NUMBER
,      INVENTORY_ITEM_ID
,      INVENTORY_ORG_ID
,      ORGANIZATION_CODE
,      UOM_CODE
,      QUANTITY
,      SERIAL_NUMBER
,      MFG_SERIAL_NUMBER_FLAG
,      REVISION
,      LOT_NUMBER
,      INSTALL_DATE
,      CSI_LOCATION_ID
,      LOCATION_DESCRIPTION
,      STATUS
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      MFG_DATE
,      SERIALNUM_TAG_CODE
,      SERIALNUM_TAG_MEANING
,      CONDITION
,      PARTY_TYPE
,      OWNER_ID
,      OWNER_NUMBER
,      OWNER_NAME
,      CSI_PARTY_OBJECT_VERSION_NUM
,      OWNER_SITE_NUMBER
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
FROM APPS.AHL_UNIT_INSTALLED_DETAILS_V;

Dependencies

[top of page]

APPS.AHL_UNIT_INSTALLED_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackageAHL_UTIL_UC_PKG - show dependent code
ViewCSI_INST_EXTEND_ATTRIB_V
ViewCSI_INST_PARTY_DETAILS_V
SynonymCSI_ITEM_INSTANCES
ViewCSI_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymMTL_MATERIAL_STATUSES
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_SYSTEM_ITEMS_TL
SynonymWIP_ENTITIES
APPS.AHL_UNIT_INSTALLED_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyAHL_FMP_PVT - show dependent code
Package BodyAHL_UC_INSTANCE_PVT - show dependent code