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: WIP.WIP_TRANSACTIONS

Object Details

Object Name:	WIP_TRANSACTIONS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_TRANSACTIONS
Subobject Name:
Status:	VALID

WIP_TRANSACTIONS stores information about WIP resource transactions. Each row represents a single resource transaction and includes a unique transaction Identifier, a transaction date, the job or repetitive schedule charged, the WIP operation and resource charges, and the number of units of measure applied. Oracle Work in Process uses this information to track resource charges and to
calculate the values stored in WIP_TRANSACTION_ACCOUNTS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_TRANSACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
WIP_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID
WIP_TRANSACTIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMPLOYEE_ID
WIP_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_DATE CREATION_DATE TRANSACTION_ID
WIP_TRANSACTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COST_UPDATE_ID WIP_ENTITY_ID
WIP_TRANSACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PM_COST_COLLECTED ORGANIZATION_ID PM_COST_COLLECTOR_GROUP_ID
WIP_TRANSACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRIMARY_ITEM_ID ORGANIZATION_ID
WIP_TRANSACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID
WIP_TRANSACTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_TRANSACTION_ID
WIP_TRANSACTIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
WIP_TRANSACTIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Transaction Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
WIP_ENTITY_ID	NUMBER		Yes	WIP job or repetitive assembly Identifier
PRIMARY_ITEM_ID	NUMBER			Inventory item Identifier of the assembly that the job or schedule creates
ACCT_PERIOD_ID	NUMBER		Yes	Accounting period Identifier
DEPARTMENT_ID	NUMBER			Department Identifier
TRANSACTION_TYPE	NUMBER		Yes	Transaction type
TRANSACTION_DATE	DATE		Yes	Date transaction was performed
GROUP_ID	NUMBER			Transaction group Identifier
LINE_ID	NUMBER			WIP line Identifier
SOURCE_CODE	VARCHAR2	(30)		Code of the source system that generated the transaction record (null if created by Oracle Work in Process)
SOURCE_LINE_ID	NUMBER			Identifier used by the source system that generated the transaction record (null if created by Oracle Work in Process)
OPERATION_SEQ_NUM	NUMBER			Operation sequence number within a routing
RESOURCE_SEQ_NUM	NUMBER			Resource requirement sequence number
EMPLOYEE_ID	NUMBER			Employee Identifier
RESOURCE_ID	NUMBER			Resource requirement Identifier
AUTOCHARGE_TYPE	NUMBER			Method of charging the resource
STANDARD_RATE_FLAG	NUMBER			Determines whether or not the resource is charged at the standard rate
USAGE_RATE_OR_AMOUNT	NUMBER			Rate per assembly or amount per job/schedule
BASIS_TYPE	NUMBER			Basis for charging the resource requirement
TRANSACTION_QUANTITY	NUMBER			Transaction quantity
TRANSACTION_UOM	VARCHAR2	(3)		Unit of measure used in the transaction
PRIMARY_QUANTITY	NUMBER			Quantity transacted expressed in the primary unit of measure
PRIMARY_UOM	VARCHAR2	(3)		Primary unit of measure
ACTUAL_RESOURCE_RATE	NUMBER			Actual rate of the resource requirement
STANDARD_RESOURCE_RATE	NUMBER			Standard rate of the resource requirement
CURRENCY_CODE	VARCHAR2	(15)		Currency code used in the transaction
CURRENCY_CONVERSION_DATE	DATE			Date of the currency conversion
CURRENCY_CONVERSION_TYPE	VARCHAR2	(10)		Currency conversion type used for the transaction
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate used for the transaction
CURRENCY_ACTUAL_RESOURCE_RATE	NUMBER			Actual resource rate converted for the currency code
ACTIVITY_ID	NUMBER			Activity Identifier
REASON_ID	NUMBER			Reason Identifier
REFERENCE	VARCHAR2	(240)		Transaction reference descriptive text
MOVE_TRANSACTION_ID	NUMBER			Move transaction Identifier
PO_HEADER_ID	NUMBER			Purchase order header Identifier
PO_LINE_ID	NUMBER			Purchase order line Identifier
RCV_TRANSACTION_ID	NUMBER			Receiving transaction Identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
REQUEST_ID	NUMBER			Enhanced Who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who column
PROGRAM_ID	NUMBER			Enhanced Who column
PROGRAM_UPDATE_DATE	DATE			Enhanced Who column
COST_UPDATE_ID	NUMBER			Identifier of the cost update process that updated the record
PM_COST_COLLECTED	VARCHAR2	(1)		Flag to indicate if costs have been collected for project manufacturing
PM_COST_COLLECTOR_GROUP_ID	NUMBER			Group identifier used for collecting costs for project manufacturing
PROJECT_ID	NUMBER			Project Identifier
TASK_ID	NUMBER			Project task Identifier
COMPLETION_TRANSACTION_ID	NUMBER			Originating completion transaction in MTL_MATERIAL_TRANSACTIONS
CHARGE_DEPARTMENT_ID	NUMBER			Department to be charged
INSTANCE_ID	NUMBER			Resource Instance Identifier
ENCUMBRANCE_TYPE_ID	NUMBER			Encumbrance type identifier
ENCUMBRANCE_AMOUNT	NUMBER			Encumbrance amount
ENCUMBRANCE_QUANTITY	NUMBER			Encumbrance quantity
ENCUMBRANCE_CCID	NUMBER			Encumbrance GL account

Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      PRIMARY_ITEM_ID
,      ACCT_PERIOD_ID
,      DEPARTMENT_ID
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      GROUP_ID
,      LINE_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      EMPLOYEE_ID
,      RESOURCE_ID
,      AUTOCHARGE_TYPE
,      STANDARD_RATE_FLAG
,      USAGE_RATE_OR_AMOUNT
,      BASIS_TYPE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      ACTUAL_RESOURCE_RATE
,      STANDARD_RESOURCE_RATE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_ACTUAL_RESOURCE_RATE
,      ACTIVITY_ID
,      REASON_ID
,      REFERENCE
,      MOVE_TRANSACTION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      RCV_TRANSACTION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COST_UPDATE_ID
,      PM_COST_COLLECTED
,      PM_COST_COLLECTOR_GROUP_ID
,      PROJECT_ID
,      TASK_ID
,      COMPLETION_TRANSACTION_ID
,      CHARGE_DEPARTMENT_ID
,      INSTANCE_ID
,      ENCUMBRANCE_TYPE_ID
,      ENCUMBRANCE_AMOUNT
,      ENCUMBRANCE_QUANTITY
,      ENCUMBRANCE_CCID
FROM WIP.WIP_TRANSACTIONS;

Dependencies

[top of page]

WIP.WIP_TRANSACTIONS does not reference any database object

WIP.WIP_TRANSACTIONS is referenced by following:

WIP: WIP_TRANSACTIONS#