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

VIEW: APPS.WIP_TRANSACTIONS_V

Object Details
Object Name: WIP_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_TRANSACTIONS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier (internal use only)
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
WIP_ENTITY_NAME VARCHAR2 (240)
Job or repetitive assembly name
PRIMARY_ITEM_ID NUMBER

Inventory item identifier of the assembly the job or schedule creates
ACCT_PERIOD_ID NUMBER
Yes Accounting period identifier
DEPARTMENT_ID NUMBER

Department identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department code
TRANSACTION_TYPE NUMBER
Yes Transaction type
TRANSACTION_TYPE_MEANING VARCHAR2 (80) Yes Transaction type meaning
TRANSACTION_DATE DATE
Yes Date transaction was performed
GROUP_ID NUMBER

Transaction group identifier
LINE_ID NUMBER

WIP line identifier
LINE_CODE VARCHAR2 (10)
Production line name
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 sequence number
EMPLOYEE_ID NUMBER

Employee identifier
EMPLOYEE_NUM VARCHAR2 (30)
User-defined employee number
RESOURCE_ID NUMBER

Resource identifier
RESOURCE_CODE VARCHAR2 (10)
Resource code
AUTOCHARGE_TYPE NUMBER

Method of charging the resource
AUTOCHARGE_TYPE_MEANING VARCHAR2 (80)
Autocharge type meaning
STANDARD_RATE_FLAG NUMBER

Flag indicating whether or not the resource is charged at the standard rate
STANDARD_RATE_MEANING VARCHAR2 (80)
Standard rate meaning. For overhead transactions, this column is null.
USAGE_RATE_OR_AMOUNT NUMBER

Rate per assembly or amount per job/schedule
BASIS_TYPE NUMBER

Basis for charging the resource
BASIS_TYPE_MEANING VARCHAR2 (80)
Basis type meaning
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
STANDARD_RESOURCE_RATE NUMBER

Standard rate of the resource
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
ACTIVITY VARCHAR2 (10)
Activity name
REASON_ID NUMBER

Reason identifier
REASON_NAME VARCHAR2 (30)
Reason name
REFERENCE VARCHAR2 (240)
Transaction reference descriptive text
MOVE_TRANSACTION_ID NUMBER

Move transaction identifier
PO_HEADER_ID NUMBER

Purchase order header identifier
PO_NUMBER VARCHAR2 (20)
PO number associated with the transaction, if outside processing
PROJECT_ID NUMBER

Project identifier
PROJECT_NUMBER VARCHAR2 (4000)
Project number
TASK_NUMBER VARCHAR2 (25)
Task numer associated with the project
TASK_ID NUMBER

Task identifier associated with the project
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

Extended Who column
PROGRAM_APPLICATION_ID NUMBER

Extended Who column
PROGRAM_ID NUMBER

Extended Who column
PROGRAM_UPDATE_DATE DATE

Extended Who column
ASSET_NUMBER VARCHAR2 (30)
ASSET_GROUP_ID NUMBER

REBUILD_ITEM_ID NUMBER

SERIAL_NUMBER VARCHAR2 (30)
ENTITY_TYPE NUMBER
Yes
PM_COST_COLLECTED VARCHAR2 (1)
PM_COST_COLLECTOR_GROUP_ID NUMBER

Query Text

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


SELECT ROW_ID
,      TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      PRIMARY_ITEM_ID
,      ACCT_PERIOD_ID
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      TRANSACTION_TYPE
,      TRANSACTION_TYPE_MEANING
,      TRANSACTION_DATE
,      GROUP_ID
,      LINE_ID
,      LINE_CODE
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      EMPLOYEE_ID
,      EMPLOYEE_NUM
,      RESOURCE_ID
,      RESOURCE_CODE
,      AUTOCHARGE_TYPE
,      AUTOCHARGE_TYPE_MEANING
,      STANDARD_RATE_FLAG
,      STANDARD_RATE_MEANING
,      USAGE_RATE_OR_AMOUNT
,      BASIS_TYPE
,      BASIS_TYPE_MEANING
,      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
,      ACTIVITY
,      REASON_ID
,      REASON_NAME
,      REFERENCE
,      MOVE_TRANSACTION_ID
,      PO_HEADER_ID
,      PO_NUMBER
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      TASK_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
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      REBUILD_ITEM_ID
,      SERIAL_NUMBER
,      ENTITY_TYPE
,      PM_COST_COLLECTED
,      PM_COST_COLLECTOR_GROUP_ID
FROM APPS.WIP_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.WIP_TRANSACTIONS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
SynonymCST_ACTIVITIES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_TRANSACTION_REASONS
SynonymPA_TASKS
ViewPER_PEOPLE_F
PL/SQL PackagePJM_PROJECT - show dependent code
SynonymPO_HEADERS_ALL
SynonymWIP_DISCRETE_JOBS
SynonymWIP_ENTITIES
ViewWIP_JOB_ASSY_LINE_V
SynonymWIP_TRANSACTIONS

APPS.WIP_TRANSACTIONS_V is not referenced by any database object