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

VIEW: APPS.AHL_UNIT_HEADER_DETAILS_V

Object Details
Object Name: AHL_UNIT_HEADER_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_UNIT_HEADER_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
UNIT_CONFIG_HEADER_ID NUMBER
Yes Unique internal UNIT_CONFIGURATION_ID from AHL_UNIT_CONFIG_HEADERS
OBJECT_VERSION_NUMBER NUMBER
Yes OBJECT_VERSION_NUMBER for AHL_UNIT_CONFIG_HEADERS record
NAME VARCHAR2 (80) Yes Name of the Unit Configuration
MASTER_CONFIG_ID NUMBER
Yes Master Configuration internal identifier
CSI_ITEM_INSTANCE_ID NUMBER
Yes Installed Base item assigned to the top node of the Master Configuration
UNIT_CONFIG_STATUS_CODE VARCHAR2 (30) Yes Unit Configuration status code
OWNER_ID NUMBER

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 (80)
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

OBJECT_VERSION_NUMBER for Install Base party instance record
CSI_OBJECT_VERSION_NUMBER NUMBER
Yes OBJECT_VERSION_NUMBER for Install Base instance record
ACTIVE_START_DATE DATE

Active Start Date for the Unit Configuration
ACTIVE_END_DATE DATE

Active End Date of the Unit Configuration
STATUS_MEANING VARCHAR2 (80)
Unit Configuration status code meaning
OWNER_SITE_ID NUMBER

It is either HZ_PARTY_SITE_ID from HZ_PARTY_SITES or VENDOR_SITE_ID from PO_VENDOR_SITES_ALL
OWNER_SITE_NUMBER VARCHAR2 (4000)
It is either PARTY_NUMBER from HZ_PARTIES or SEGMENT1 from PO_VENDORS
LOCATION_DESCRIPTION VARCHAR2 (4000)
Item's location description
SERIAL_NUMBER VARCHAR2 (30)
Serial number of the Install Base item
POSITION_REF_CODE VARCHAR2 (30) Yes Master Configuration top node code
POSITION_REF_MEANING VARCHAR2 (80)
Master Configuration top node position meaning
MASTER_CONFIG_NAME VARCHAR2 (80) Yes Master Configuration name
MASTER_CONFIG_REVISION VARCHAR2 (30) Yes Indicates the revision of the MC from which the UC is built. This column is displayable for user.
MASTER_CONFIG_DESCRIPTION VARCHAR2 (2000)
Master Configuration description
ITEM_NUMBER VARCHAR2 (40)
Item number from Inventory
ITEM_DESCRIPTION VARCHAR2 (240)
Item description from Inventory
Query Text

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


SELECT UNIT_CONFIG_HEADER_ID
,      OBJECT_VERSION_NUMBER
,      NAME
,      MASTER_CONFIG_ID
,      CSI_ITEM_INSTANCE_ID
,      UNIT_CONFIG_STATUS_CODE
,      OWNER_ID
,      OWNER_NUMBER
,      OWNER_NAME
,      PARTY_TYPE
,      CSI_PARTY_OBJECT_VERSION_NUM
,      CSI_OBJECT_VERSION_NUMBER
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      STATUS_MEANING
,      OWNER_SITE_ID
,      OWNER_SITE_NUMBER
,      LOCATION_DESCRIPTION
,      SERIAL_NUMBER
,      POSITION_REF_CODE
,      POSITION_REF_MEANING
,      MASTER_CONFIG_NAME
,      MASTER_CONFIG_REVISION
,      MASTER_CONFIG_DESCRIPTION
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
FROM APPS.AHL_UNIT_HEADER_DETAILS_V;

Dependencies

[top of page]

APPS.AHL_UNIT_HEADER_DETAILS_V references the following:

SchemaAPPS
ViewAHL_MC_HEADERS_VL
SynonymAHL_MC_RELATIONSHIPS
SynonymAHL_UNIT_CONFIG_HEADERS
PL/SQL PackageAHL_UTIL_UC_PKG - show dependent code
ViewCSI_INST_PARTY_DETAILS_V
SynonymCSI_ITEM_INSTANCES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWIP_ENTITIES
APPS.AHL_UNIT_HEADER_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyAHL_UMP_UF_PVT - show dependent code