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_CONFIG_HEADERS_V

Object Details

Object Name:	AHL_UNIT_CONFIG_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_UNIT_CONFIG_HEADERS_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
UC_HEADER_ID	NUMBER		Yes	Primary Key
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
UC_NAME	VARCHAR2	(80)	Yes	Name of the unit configuration
MC_HEADER_ID	NUMBER		Yes	Master Configuration from which this Unit Configuration is constructed
MC_NAME	VARCHAR2	(80)	Yes	Name of the Master Configuration from which the UC is built
MC_REVISION	VARCHAR2	(30)	Yes	Revision of the Master Configuration from which the UC is built.
MC_STATUS_CODE	VARCHAR2	(30)	Yes	The status code of the master configuration from which the UC is built.
MC_STATUS	VARCHAR2	(80)	Yes	The status meaning of the master configuration from which the UC is built.
MC_DESCRIPTION	VARCHAR2	(2000)		The description of the master configuration from which the UC is built.
POSITION_REF_CODE	VARCHAR2	(30)	Yes	The top node position reference code of the master configuration from which the UC is built.
POSITION_REF	VARCHAR2	(80)	Yes	The top node position reference meaning of the master configuration from which the UC is built.
MC_ACTIVE_START_DATE	DATE			Active Start Date of the master configuration from which the UC is built.
MC_ACTIVE_END_DATE	DATE			Active End Date of the master configuration from which the UC is built. Actually it is the active end date of the MC's top node.
CSI_INSTANCE_ID	NUMBER		Yes	Link to the topmost node of the Unit Configuration
CSI_INSTANCE_OVN	NUMBER		Yes	Object version number of the instance in table csi_item_instances. The UC is built for this particular instance.
ITEM_NUMBER	VARCHAR2	(40)		Item number of the item which the instance belongs to. Concatenated segments in mtl_sysmte_items_kfv.
INSTANCE_NUMBER	VARCHAR2	(30)	Yes	Instance Number of the instance for which the UC is built.
SERIAL_NUMBER	VARCHAR2	(30)		Serial Number of the instance for which the UC is built.
LOT_NUMBER	VARCHAR2	(80)		Lot Number of the instance for which the UC is built.
INSTANCE_START_DATE	DATE			The active start date of the top instance of the UC.
INSTANCE_END_DATE	DATE			The active end date of the top instance of the UC.
ACTIVE_START_DATE	DATE			Active Start Date of the unit (no longer use since 11.5.10)
ACTIVE_END_DATE	DATE			Active End Date of the unit configuration.
UC_STATUS_CODE	VARCHAR2	(30)	Yes	Status code of the Unit Configuration (DRAFT or COMPLETE/INCOMPLETE)
UC_STATUS	VARCHAR2	(80)	Yes	Status meaning of the Unit Configuration (DRAFT, APPROVAL_PENDING, APPROVAL_REJECTED, COMPLETE and INCOMPLETE)
ACTIVE_UC_STATUS_CODE	VARCHAR2	(30)		Indicates the workflow status change for a Complete or Incomplete UC
ACTIVE_UC_STATUS	VARCHAR2	(80)		Active UC Status meaning indicates the workflow status change for a Complete or Incomplete UC
PARENT_UC_HEADER_ID	NUMBER			Indicates its parent uc_header_id if the UC is a sub UC
PARENT_UC_NAME	VARCHAR2	(80)		Parent UC name if the UC is a sub UC.
PARENT_INSTANCE_ID	NUMBER			Parent instance_id if the UC's top instance is another instance's child
ROOT_UC_HEADER_ID	NUMBER			The root UC header ID if the UC is installed in other UCs.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column

Query Text

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


SELECT UC_HEADER_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      UC_NAME
,      MC_HEADER_ID
,      MC_NAME
,      MC_REVISION
,      MC_STATUS_CODE
,      MC_STATUS
,      MC_DESCRIPTION
,      POSITION_REF_CODE
,      POSITION_REF
,      MC_ACTIVE_START_DATE
,      MC_ACTIVE_END_DATE
,      CSI_INSTANCE_ID
,      CSI_INSTANCE_OVN
,      ITEM_NUMBER
,      INSTANCE_NUMBER
,      SERIAL_NUMBER
,      LOT_NUMBER
,      INSTANCE_START_DATE
,      INSTANCE_END_DATE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      UC_STATUS_CODE
,      UC_STATUS
,      ACTIVE_UC_STATUS_CODE
,      ACTIVE_UC_STATUS
,      PARENT_UC_HEADER_ID
,      PARENT_UC_NAME
,      PARENT_INSTANCE_ID
,      ROOT_UC_HEADER_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.AHL_UNIT_CONFIG_HEADERS_V;

Dependencies

[top of page]

APPS.AHL_UNIT_CONFIG_HEADERS_V references the following:

APPS: AHL_MC_HEADERS_B; AHL_MC_HEADERS_TL; AHL_MC_RELATIONSHIPS; AHL_UNIT_CONFIG_HEADERS; CSI_II_RELATIONSHIPS; CSI_ITEM_INSTANCES; FND_LOOKUP_VALUES; INV_ORGANIZATION_INFO_V; MO_GLOBAL - show dependent code; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV

APPS.AHL_UNIT_CONFIG_HEADERS_V is referenced by following:

APPS: AHL_PRD_MRSHL_PVT - show dependent code; AHL_UC_INSTANCE_PVT - show dependent code; AHL_UC_UNITCONFIG_PVT - show dependent code