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]

TABLE: AHL.AHL_OPERATIONS_B

Object Details

Object Name:	AHL_OPERATIONS_B
Object Type:	TABLE
Owner:	AHL
FND Design Data:	AHL.AHL_OPERATIONS_B
Subobject Name:
Status:	VALID

This table stores the Standard and Non Standard operations. An operation has a user defined identifier which is stored in SEGMENT1 through SEGMENT15. An operation can be changed from Non Standard to Standard but not vice-versa. Operations are associated with different Routes. Operations have details of tasks and resources that are needed in order to complete any type of maintenance. The attribute REVISION_STATUS_CODE can have the values Draft or Complete.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AHL_OPERATIONS_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	OPERATION_ID
AHL_OPERATIONS_B_U2	NORMAL	UNIQUE	APPS_TS_SEED	SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 SEGMENT11 SEGMENT12 SEGMENT13 SEGMENT14 SEGMENT15 REVISION_NUMBER
AHL_OPERATIONS_B_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	OPERATION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
OPERATION_ID	NUMBER		Yes	Primary Key, Unique identifier of an operation
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REVISION_NUMBER	NUMBER		Yes	Version number of the operation which indicates how many times an operation was modified
REVISION_STATUS_CODE	VARCHAR2	(30)	Yes	This attribute indicates the status of the operation, Whether it is current, draft, or archived
STANDARD_OPERATION_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the operation is standard or not
ACTIVE_START_DATE	DATE			This attribute indicates the date from which the operation will be activated
ACTIVE_END_DATE	DATE			This attribute indicates the date from which the operation will be deactivated
OPERATION_NUMBER	NUMBER			Obsolete. Unique number to identify a non standard operation
SEGMENT1	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT2	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT3	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT4	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT5	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT6	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT7	VARCHAR2	(30)		User defined attribute to identify an operation
PRODUCT_TYPE_CODE	VARCHAR2	(30)		Obsolete. Identifier for product type
ZONE_CODE	VARCHAR2	(30)		Obsolete. Identifier for Zone
SUB_ZONE_CODE	VARCHAR2	(30)		Obsolete. Identifier for sub Zone
OPERATION_CATEGORY_CODE	VARCHAR2	(30)		Obsolete.This is an identifier of the category of the operation
OPERATION_TYPE_CODE	VARCHAR2	(30)		This is an identifier of the type of the operation
WORK_CENTER_CODE	VARCHAR2	(30)		This is a production planning parameter
SYSTEM_CODE1	VARCHAR2	(30)		Obsolete. This is a production planning parameter
SYSTEM_CODE2	VARCHAR2	(30)		Obsolete. This is a production planning parameter
SYSTEM_CODE3	VARCHAR2	(30)		Obsolete. This is a production planning parameter
PROCESS_CODE	VARCHAR2	(30)		This is a production planning parameter
OPERATOR_CODE	VARCHAR2	(30)		No longer used
OPERATOR_PARTY_ID	NUMBER	(15)		Obsolete. This attribute stores the Operator of the product
OPRPRIM_SKILL_TYPE_CODE	VARCHAR2	(30)		No longer used
SKILL_COMPETENCE_ID	NUMBER	(15)		Obsolete. This attribute identifies the primary skill required for an operation. (Skill Type)
TIME_SPAN	NUMBER			Obsolete. Total time span needed for an operation.
SECURITY_GROUP_ID	NUMBER			Used in application hosting
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
QA_PLAN_ID	NUMBER			Attribute to set up a QA plan to record maintenance execution accomplishments.
SEGMENT8	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT9	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT10	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT11	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT12	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT13	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT14	VARCHAR2	(30)		User defined attribute to identify an operation
SEGMENT15	VARCHAR2	(30)		User defined attribute to identify an operation
SUMMARY_FLAG	VARCHAR2	(1)		Standard Key Flexfield Column
ENABLED_FLAG	VARCHAR2	(1)		Standard Key Flexfield Column
START_DATE_ACTIVE	DATE			This attribute indicates the date from which the operation will be activated
END_DATE_ACTIVE	DATE			This attribute indicates the date from which the operation will be deactivated
QA_INSPECTION_TYPE	VARCHAR2	(150)		QA_INSPECTION_TYPE
MODEL_CODE	VARCHAR2	(30)		Model Code.
ENIGMA_OP_ID	VARCHAR2	(80)		Enigma Operation Identifier

Query Text

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


SELECT OPERATION_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REVISION_NUMBER
,      REVISION_STATUS_CODE
,      STANDARD_OPERATION_FLAG
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      OPERATION_NUMBER
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      PRODUCT_TYPE_CODE
,      ZONE_CODE
,      SUB_ZONE_CODE
,      OPERATION_CATEGORY_CODE
,      OPERATION_TYPE_CODE
,      WORK_CENTER_CODE
,      SYSTEM_CODE1
,      SYSTEM_CODE2
,      SYSTEM_CODE3
,      PROCESS_CODE
,      OPERATOR_CODE
,      OPERATOR_PARTY_ID
,      OPRPRIM_SKILL_TYPE_CODE
,      SKILL_COMPETENCE_ID
,      TIME_SPAN
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      QA_PLAN_ID
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      QA_INSPECTION_TYPE
,      MODEL_CODE
,      ENIGMA_OP_ID
FROM AHL.AHL_OPERATIONS_B;

Dependencies

[top of page]

AHL.AHL_OPERATIONS_B does not reference any database object

AHL.AHL_OPERATIONS_B is referenced by following:

APPS: AHL_OPERATIONS_B