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


VIEW: APPS.EAM_CFR_WORK_COMPLETION_V

Object Details
Object Name: EAM_CFR_WORK_COMPLETION_V
Object Type: VIEW
Owner: APPS
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_ID NUMBER
Yes Transaction identifier for the complete/uncomplete transaction
TRANSACTION_TYPE NUMBER
Yes Type of transaction (complete or uncomplete)
TRANSACTION_NAME VARCHAR2 (80) Yes Transaction Name
TRANSACTION_DATE DATE
Yes Date of the complete or uncomplete transaction
ORGANIZATION_ID NUMBER
Yes Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
WIP_ENTITY_ID NUMBER
Yes Work order identifier
ACTUAL_START_DATE DATE

Actual Start Date of the work order
ACTUAL_DURATION NUMBER

Actual Duration of the work order
ACTUAL_END_DATE DATE

Actual End Date of the work order
RECONCILIATION_CODE VARCHAR2 (80)
Reconciliation code used to store the result of a performed maintenance task
COMPLETION_SUBINVENTORY VARCHAR2 (10)
Completion Subinventory Code
COMPLETION_LOCATOR_ID NUMBER

Completion Locator identifier
LOCATOR_NAME VARCHAR2 (1)
Locator Name
LOT_NUMBER VARCHAR2 (80)
Lot Number
Query Text

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


SELECT TRANSACTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_NAME
,      TRANSACTION_DATE
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      WIP_ENTITY_ID
,      ACTUAL_START_DATE
,      ACTUAL_DURATION
,      ACTUAL_END_DATE
,      RECONCILIATION_CODE
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      LOCATOR_NAME
,      LOT_NUMBER
FROM APPS.EAM_CFR_WORK_COMPLETION_V;

Dependencies

[top of page]

APPS.EAM_CFR_WORK_COMPLETION_V references the following:

SchemaAPPS
SynonymEAM_JOB_COMPLETION_TXNS
ViewMFG_LOOKUPS
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_PARAMETERS

APPS.EAM_CFR_WORK_COMPLETION_V is not referenced by any database object