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_WO_OPERATIONS_TXNS

Object Details

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

Ahl Production Workorder Operations Information stored in this table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AHL_WO_OPERATIONS_TXNS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WO_OPERATION_TXN_ID
AHL_WO_OPERATIONS_TXNS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKORDER_OPERATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WO_OPERATION_TXN_ID	NUMBER		Yes	PK for AHL_WO_OPERATIONS_TXNS
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
WORKORDER_OPERATION_ID	NUMBER		Yes	FK to table AHL_WORKORDER_OPERATIONS
OPERATION_RESOURCE_ID	NUMBER			FK to table AHL_OPERATION_RESOURCES
SCHEDULE_MATERIAL_ID	NUMBER			FK to table AHL_SCHEDULE_MATERIALS
BOM_RESOURCE_ID	NUMBER			FK to table BOM_RESOURCES
LOAD_TYPE_CODE	NUMBER		Yes	LoadTypeCode
TRANSACTION_TYPE_CODE	NUMBER		Yes	TransactionTypeCode
COST_BASIS_CODE	NUMBER			CostBasisCode
TOTAL_REQUIRED	NUMBER			TotalRequired
ASSIGNED_UNITS	NUMBER			AssignedUnits
AUTOCHARGE_TYPE_CODE	NUMBER			AutoChargeTypeCode
STANDARD_RATE_FLAG_CODE	NUMBER			StabdardRateFlagCode
APPLIED_RESOURCE_UNITS	NUMBER			AppliedReourceUnits
APPLIED_RESOURCE_VALUE	NUMBER			AppliedReourceValue
INVENTORY_ITEM_ID	NUMBER			InventoryItemId
SCHEDULED_QUANTITY	NUMBER			ScheduleQuantity
SCHEDULED_DATE	DATE			ScheduleDate
MRP_NET_FLAG	NUMBER			MrpNetFlag
QUANTITY_PER_ASSEMBLY	NUMBER			QuantityPerAssembly
REQUIRED_QUANTITY	NUMBER			RequiredQuantity
SUPPLY_LOCATOR_ID	NUMBER			SupplyLocatorId
SUPPLY_SUBINVENTORY	VARCHAR2	(10)		SupplySubinventory
DATE_REQUIRED	DATE			DateRequired
OPERATION_TYPE_CODE	VARCHAR2	(30)		OperationTypeCode
RES_SCHED_START_DATE	DATE			ResschedStartDate
RES_SCHED_END_DATE	DATE			ResSchedEndDate
OP_SCHEDULED_START_DATE	DATE			OpScheduledStartDate
OP_SCHEDULED_END_DATE	DATE			OpScheduledEndDate
OP_ACTUAL_START_DATE	DATE			OpActualStartDate
OP_ACTUAL_END_DATE	DATE			OpActualEndDate
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

Query Text

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


SELECT WO_OPERATION_TXN_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WORKORDER_OPERATION_ID
,      OPERATION_RESOURCE_ID
,      SCHEDULE_MATERIAL_ID
,      BOM_RESOURCE_ID
,      LOAD_TYPE_CODE
,      TRANSACTION_TYPE_CODE
,      COST_BASIS_CODE
,      TOTAL_REQUIRED
,      ASSIGNED_UNITS
,      AUTOCHARGE_TYPE_CODE
,      STANDARD_RATE_FLAG_CODE
,      APPLIED_RESOURCE_UNITS
,      APPLIED_RESOURCE_VALUE
,      INVENTORY_ITEM_ID
,      SCHEDULED_QUANTITY
,      SCHEDULED_DATE
,      MRP_NET_FLAG
,      QUANTITY_PER_ASSEMBLY
,      REQUIRED_QUANTITY
,      SUPPLY_LOCATOR_ID
,      SUPPLY_SUBINVENTORY
,      DATE_REQUIRED
,      OPERATION_TYPE_CODE
,      RES_SCHED_START_DATE
,      RES_SCHED_END_DATE
,      OP_SCHEDULED_START_DATE
,      OP_SCHEDULED_END_DATE
,      OP_ACTUAL_START_DATE
,      OP_ACTUAL_END_DATE
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM AHL.AHL_WO_OPERATIONS_TXNS;

Dependencies

[top of page]

AHL.AHL_WO_OPERATIONS_TXNS does not reference any database object

AHL.AHL_WO_OPERATIONS_TXNS is referenced by following:

APPS: AHL_WO_OPERATIONS_TXNS