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


VIEW: APPS.WIPFV_WIP_MOVE_TRANSACTIONS

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

View Type

A Business Intelligence System view


This shows the transactions associated with shop floor moves. Move transactions track the number of assemblies moved between the operations and intraoperation steps of jobs and repetitive schedules.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_DATE DATE
Yes
GROUP_ID NUMBER
Yes
FROM_INTRAOPERATION_STEP NUMBER
Yes
TO_INTRAOPERATION_STEP NUMBER
Yes
TRANSACTION_QUANTITY NUMBER
Yes
TRANSACTION_REFERENCE VARCHAR2 (240)
PRIMARY_QUANTITY NUMBER
Yes
OVERCOMPLETION_TRANSACTION_QTY NUMBER

OVERCOMPLETION_PRIMARY_QTY NUMBER

FROM_DEPARTMENT VARCHAR2 (10) Yes
TO_DEPARTMENT VARCHAR2 (10) Yes
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_NAME VARCHAR2 (240) Yes
MFG_ORDER_NAME VARCHAR2 (240) Yes
LINE_NAME VARCHAR2 (10)
_KF:ITEM_NUMBER CHAR (15)
PERIOD_NAME VARCHAR2 (15) Yes
FROM_OPERATION VARCHAR2 (4)
TO_OPERATION VARCHAR2 (4)
TRANSACTION_UOM_CODE VARCHAR2 (25) Yes
PRIMARY_UOM_CODE VARCHAR2 (25) Yes
_KF:ACCOUNT_NUM:SCRAP:_CO CHAR (16)
QA_PLAN_NAME VARCHAR2 (30)
REASON VARCHAR2 (30)
_DF CHAR (32)
TRANSACTION_ID NUMBER
Yes
FM_DEPARTMENT_ID NUMBER
Yes
TO_DEPARTMENT_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
WIP_ENTITY_ID NUMBER
Yes
LINE_ID NUMBER

PRIMARY_ITEM_ID NUMBER

ACCT_PERIOD_ID NUMBER
Yes
FROM_OPERATION_SEQ_NUMBER NUMBER
Yes
TO_OPERATION_SEQ_NUMBER NUMBER
Yes
TRANSACTION_UOM VARCHAR2 (3) Yes
PRIMARY_UOM VARCHAR2 (3) Yes
SCRAP_ACCOUNT_ID NUMBER

QA_COLLECTION_ID NUMBER

REASON_ID NUMBER

OVERCOMPLETION_TRANSACTION_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
Query Text

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


SELECT TRANSACTION_DATE
,      GROUP_ID
,      FROM_INTRAOPERATION_STEP
,      TO_INTRAOPERATION_STEP
,      TRANSACTION_QUANTITY
,      TRANSACTION_REFERENCE
,      PRIMARY_QUANTITY
,      OVERCOMPLETION_TRANSACTION_QTY
,      OVERCOMPLETION_PRIMARY_QTY
,      FROM_DEPARTMENT
,      TO_DEPARTMENT
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      MFG_ORDER_NAME
,      LINE_NAME
,      _KF:ITEM_NUMBER
,      PERIOD_NAME
,      FROM_OPERATION
,      TO_OPERATION
,      TRANSACTION_UOM_CODE
,      PRIMARY_UOM_CODE
,      _KF:ACCOUNT_NUM:SCRAP:_CO
,      QA_PLAN_NAME
,      REASON
,      _DF
,      TRANSACTION_ID
,      FM_DEPARTMENT_ID
,      TO_DEPARTMENT_ID
,      ORGANIZATION_ID
,      WIP_ENTITY_ID
,      LINE_ID
,      PRIMARY_ITEM_ID
,      ACCT_PERIOD_ID
,      FROM_OPERATION_SEQ_NUMBER
,      TO_OPERATION_SEQ_NUMBER
,      TRANSACTION_UOM
,      PRIMARY_UOM
,      SCRAP_ACCOUNT_ID
,      QA_COLLECTION_ID
,      REASON_ID
,      OVERCOMPLETION_TRANSACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.WIPFV_WIP_MOVE_TRANSACTIONS;

Dependencies

[top of page]

APPS.WIPFV_WIP_MOVE_TRANSACTIONS references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymGL_CODE_COMBINATIONS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_UNITS_OF_MEASURE
SynonymORG_ACCT_PERIODS
SynonymQA_PLANS
SynonymQA_RESULTS
SynonymWIP_ENTITIES
SynonymWIP_LINES
SynonymWIP_MOVE_TRANSACTIONS

APPS.WIPFV_WIP_MOVE_TRANSACTIONS is not referenced by any database object