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

TABLE: WIP.WIP_COST_TXN_INTERFACE

Object Details
Object Name: WIP_COST_TXN_INTERFACE
Object Type: TABLE
Owner: WIP
FND Design Data: TableWIP.WIP_COST_TXN_INTERFACE
Subobject Name:
Status: VALID


WIP_COST_TXN_INTERFACE contains information about cost transactions
that Oracle Work in Process needs to process. Each row represents
either a resource transaction, an overhead transaction, an outside
processing transaction, a cost update transaction, a period close
variance transaction, or a job close variance transaction. Each row
contains the transaction date, the job or repetitive schedule to
charge, the resource to charge, the primary unit of measure
transaction quantity, and the actual unit of measure transaction
quantity. Each row also has foreign key references to
move and receiving transaction tables. Oracle Work in Process uses
this table to support all resource cost transactions including
transactions loaded from other systems through the
Oracle Work in Process Open Resource Transaction Interface.
Scope: public
Product: WIP
Lifecycle: active
Display Name: WIP Cost Transaction Interface
Category: BUSINESS_ENTITY WIP_RESOURCE_TRANSACTION


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WIP_COST_TXN_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnGROUP_ID
ColumnTRANSACTION_ID
WIP_COST_TXN_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOMPLETION_TRANSACTION_ID
WIP_COST_TXN_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnORGANIZATION_ID
ColumnPRIMARY_ITEM_ID
WIP_COST_TXN_INTERFACE_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPO_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

Transaction Identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATED_BY_NAME VARCHAR2 (100)
Username of person that last updated the record
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER

Standard Who column
CREATED_BY_NAME VARCHAR2 (100)
Username of person that created the record
LAST_UPDATE_LOGIN NUMBER

Standard Who column
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
GROUP_ID NUMBER

Transaction group identifier
SOURCE_CODE VARCHAR2 (30)
Code of the shop floor control system that generated the transaction record (null if created by Oracle Work in Process)
SOURCE_LINE_ID NUMBER

Identifier used by source shop floor control system (null if created by Oracle Work in Process)
PROCESS_PHASE NUMBER
Yes Transaction processing phase
PROCESS_STATUS NUMBER
Yes Transaction processing status
TRANSACTION_TYPE NUMBER

Transaction type
ORGANIZATION_ID NUMBER

Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Short code that uniquely identifies the organization
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly identifier
WIP_ENTITY_NAME VARCHAR2 (240)
WIP job or repetitive assembly name
ENTITY_TYPE NUMBER

WIP entity type code
LINE_ID NUMBER

WIP line identifier
LINE_CODE VARCHAR2 (10)
Line name
PRIMARY_ITEM_ID NUMBER

Inventory item identifier of assembly that job or schedule creates
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule identifier (this column is solely for internal use)
TRANSACTION_DATE DATE
Yes Date transaction was performed
ACCT_PERIOD_ID NUMBER

Accounting period Identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number within a routing
RESOURCE_SEQ_NUM NUMBER

Resource sequence number
DEPARTMENT_ID NUMBER

Department Identifier
DEPARTMENT_CODE VARCHAR2 (10)
Short code that uniquely identifies the department
EMPLOYEE_ID NUMBER

Employee Identifier
EMPLOYEE_NUM VARCHAR2 (30)
Employee number
RESOURCE_ID NUMBER

Resource Identifier
RESOURCE_CODE VARCHAR2 (10)
Resource code
RESOURCE_TYPE NUMBER

Resource type
USAGE_RATE_OR_AMOUNT NUMBER

Rate per assembly or amount per job/schedule
BASIS_TYPE NUMBER

Basis for charging resource
AUTOCHARGE_TYPE NUMBER

Method of charging the resource
STANDARD_RATE_FLAG NUMBER

Indicates whether the resource is charged at the standard rate
TRANSACTION_QUANTITY NUMBER

Transaction quantity
TRANSACTION_UOM VARCHAR2 (3)
Unit of measure used for transaction
PRIMARY_QUANTITY NUMBER

Quantity of transaction expressed in assembly's primary unit of measure
PRIMARY_UOM VARCHAR2 (3)
Primary unit of measure for the resource
PRIMARY_UOM_CLASS VARCHAR2 (10)
Class to which the primary unit of measure belongs
ACTUAL_RESOURCE_RATE NUMBER

Actual rate of the resource
CURRENCY_CODE VARCHAR2 (15)
Unique Identifier for the currency
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
CURRENCY_CONVERSION_TYPE VARCHAR2 (10)
Foreign currency conversion type
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
CURRENCY_ACTUAL_RESOURCE_RATE NUMBER

Actual resource rate in foreign currency, used when the STANDARD_RATE_FLAG is 'Y'
ACTIVITY_ID NUMBER

Activity Identifier
ACTIVITY_NAME VARCHAR2 (10)
Activity name
REASON_ID NUMBER

Standard transaction reason identifier
REASON_NAME VARCHAR2 (30)
Standard transaction reason name
REFERENCE VARCHAR2 (240)
Transaction reference descriptive text
MOVE_TRANSACTION_ID NUMBER

Transaction Identifier for the move that created the costing transaction
COMPLETION_TRANSACTION_ID NUMBER

Transaction Identifier for the Completion that created the costing transaction
RCV_TRANSACTION_ID NUMBER

Transaction Identifier for the receipt that created the costing transaction
PO_HEADER_ID NUMBER

Purchase order Identifier that the receipt is against
PO_LINE_ID NUMBER

Purchase order line Identifier that the receipt is against
RECEIVING_ACCOUNT_ID NUMBER

Receiving account Identifier
PROJECT_ID NUMBER

Project Identifier
TASK_ID NUMBER

Project task 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
PHANTOM_FLAG NUMBER

Indicates whether or not this transaction is for a phantom resource
XML_DOCUMENT_ID VARCHAR2 (240)
Identifies the XML msg that triggers the transaction
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
,      LAST_UPDATED_BY_NAME
,      CREATION_DATE
,      CREATED_BY
,      CREATED_BY_NAME
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GROUP_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      PROCESS_PHASE
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      ENTITY_TYPE
,      LINE_ID
,      LINE_CODE
,      PRIMARY_ITEM_ID
,      REPETITIVE_SCHEDULE_ID
,      TRANSACTION_DATE
,      ACCT_PERIOD_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      EMPLOYEE_ID
,      EMPLOYEE_NUM
,      RESOURCE_ID
,      RESOURCE_CODE
,      RESOURCE_TYPE
,      USAGE_RATE_OR_AMOUNT
,      BASIS_TYPE
,      AUTOCHARGE_TYPE
,      STANDARD_RATE_FLAG
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      PRIMARY_UOM_CLASS
,      ACTUAL_RESOURCE_RATE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_ACTUAL_RESOURCE_RATE
,      ACTIVITY_ID
,      ACTIVITY_NAME
,      REASON_ID
,      REASON_NAME
,      REFERENCE
,      MOVE_TRANSACTION_ID
,      COMPLETION_TRANSACTION_ID
,      RCV_TRANSACTION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      RECEIVING_ACCOUNT_ID
,      PROJECT_ID
,      TASK_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PHANTOM_FLAG
,      XML_DOCUMENT_ID
,      CHARGE_DEPARTMENT_ID
,      INSTANCE_ID
,      ENCUMBRANCE_TYPE_ID
,      ENCUMBRANCE_AMOUNT
,      ENCUMBRANCE_QUANTITY
,      ENCUMBRANCE_CCID
FROM WIP.WIP_COST_TXN_INTERFACE;

Dependencies

[top of page]

WIP.WIP_COST_TXN_INTERFACE does not reference any database object

WIP.WIP_COST_TXN_INTERFACE is referenced by following:

SchemaWIP
ViewWIP_COST_TXN_INTERFACE#