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

VIEW: APPS.WIP_TXN_COMP_INTERFACE_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_DATE DATE
Yes Transaction date
OPERATION_SEQ_NUM NUMBER

Operation sequence number
REVISION VARCHAR2 (3)
Revision
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory code
TRANSACTION_UOM VARCHAR2 (3) Yes Transaction UOM
TRANSACTION_REFERENCE VARCHAR2 (240)
Transaction reference
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
WIP_ENTITY_TYPE NUMBER

WIP entity type
ORGANIZATION_ID NUMBER
Yes Organization identifier
ACCT_PERIOD_ID NUMBER

Accounting period identifier
INVENTORY_ITEM_ID NUMBER

Item identifier
LOCATOR_ID NUMBER

Locator identifier
REASON_ID NUMBER

Reason
PARENT_ID NUMBER

Parent identifier
SCHEDULE_GROUP NUMBER

Schedule group
TRANSACTION_QUANTITY NUMBER
Yes Quantity entered at transaction time
VALIDATION_REQUIRED NUMBER

Flag for whether validation is required
PROCESS_FLAG NUMBER (1) Yes Flag for whether to process this transaction
TRANSACTION_INTERFACE_ID NUMBER

Row identifier in interface table
TRANSACTION_HEADER_ID NUMBER

Group identifier in interface table
TRANSACTION_MODE NUMBER
Yes Transaction mode
TRANSACTION_SOURCE_ID NUMBER

Transaction source identifier
TRANSACTION_SOURCE_TYPE_ID NUMBER

Transaction source type
TRANSACTION_ACTION_ID NUMBER

Transaction action identifier
TRANSACTION_TYPE_ID NUMBER
Yes Transaction type
SOURCE_CODE VARCHAR2 (30) Yes Source code
SOURCE_LINE_ID NUMBER
Yes Source line identifier
SOURCE_HEADER_ID NUMBER
Yes Source header identifier
SOURCE_TASK_ID NUMBER

Source task identifier
SOURCE_PROJECT_ID NUMBER

Source project identifier
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
FLOW_SCHEDULE VARCHAR2 (1)
Flow schedule
PRIMARY_QUANTITY NUMBER

Primary quantity
COMPONENT_ITEM VARCHAR2 (40)
Component item
LOT_CONTROL NUMBER

Lot control flag
COMPLETION_TRANSACTION_ID NUMBER

Completion Transaction Identifier
TRANSACTION_BATCH_SEQ NUMBER

Transaction batch sequence
TRANSACTION_BATCH_ID NUMBER

Transaction batch identifier
Query Text

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


SELECT TRANSACTION_DATE
,      OPERATION_SEQ_NUM
,      REVISION
,      SUBINVENTORY_CODE
,      TRANSACTION_UOM
,      TRANSACTION_REFERENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WIP_ENTITY_TYPE
,      ORGANIZATION_ID
,      ACCT_PERIOD_ID
,      INVENTORY_ITEM_ID
,      LOCATOR_ID
,      REASON_ID
,      PARENT_ID
,      SCHEDULE_GROUP
,      TRANSACTION_QUANTITY
,      VALIDATION_REQUIRED
,      PROCESS_FLAG
,      TRANSACTION_INTERFACE_ID
,      TRANSACTION_HEADER_ID
,      TRANSACTION_MODE
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_TYPE_ID
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      SOURCE_HEADER_ID
,      SOURCE_TASK_ID
,      SOURCE_PROJECT_ID
,      PROJECT_ID
,      TASK_ID
,      FLOW_SCHEDULE
,      PRIMARY_QUANTITY
,      COMPONENT_ITEM
,      LOT_CONTROL
,      COMPLETION_TRANSACTION_ID
,      TRANSACTION_BATCH_SEQ
,      TRANSACTION_BATCH_ID
FROM APPS.WIP_TXN_COMP_INTERFACE_V;

Dependencies

[top of page]

APPS.WIP_TXN_COMP_INTERFACE_V references the following:

SchemaAPPS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_TRANSACTIONS_INTERFACE

APPS.WIP_TXN_COMP_INTERFACE_V is not referenced by any database object