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


VIEW: APPS.EAM_CFR_OPERATIONS_V

Object Details
Object Name: EAM_CFR_OPERATIONS_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
WIP_ENTITY_ID NUMBER
Yes WIP job or schedule Identifier
OPERATION_SEQ_NUM NUMBER
Yes Operation sequence number within a routing
ORGANIZATION_ID NUMBER
Yes Organization Identifier
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule Identifier
OPERATION_SEQUENCE_ID NUMBER

Operation sequence Identifier
STANDARD_OPERATION_ID NUMBER

Standard operation Identifier
OPERATION_CODE VARCHAR2 (4)
Operation Code
DEPARTMENT_ID NUMBER
Yes Department Identifier
DEPARTMENT_CODE VARCHAR2 (10) Yes Department Code
LOCATION_ID NUMBER

Location Identifier
DESCRIPTION VARCHAR2 (240)
Operation description
SCHEDULED_QUANTITY NUMBER
Yes Number of units scheduled for the operation
QUANTITY_IN_QUEUE NUMBER
Yes Number of units in Queue of the operation
QUANTITY_RUNNING NUMBER
Yes Number of units in To Run of the operation
QUANTITY_WAITING_TO_MOVE NUMBER
Yes Number of units waiting To Move in the operation
QUANTITY_REJECTED NUMBER
Yes Number of units rejected from the operation
QUANTITY_SCRAPPED NUMBER
Yes Number of units scrapped from the operation
QUANTITY_COMPLETED NUMBER
Yes Number of units completed by the operation
FIRST_UNIT_START_DATE DATE
Yes First unit scheduled receipt date
FIRST_UNIT_COMPLETION_DATE DATE
Yes First unit scheduled completion date
LAST_UNIT_START_DATE DATE
Yes Last unit scheduled receipt date
LAST_UNIT_COMPLETION_DATE DATE
Yes Last unit scheduled completion date
PREVIOUS_OPERATION_SEQ_NUM NUMBER

Previous operation sequence number
NEXT_OPERATION_SEQ_NUM NUMBER

Next operation sequence number
COUNT_POINT_TYPE NUMBER
Yes Operation move type
COUNT_POINT_TYPE_DISP VARCHAR2 (80) Yes Operation move type description
BACKFLUSH_FLAG NUMBER
Yes Backflush control code
BACKFLUSH_FLAG_DISP VARCHAR2 (80) Yes Backflush control code description
MINIMUM_TRANSFER_QUANTITY NUMBER
Yes Minimum operation transfer quantity
DATE_LAST_MOVED DATE

Operation last move date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard DFF Column
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column
OPERATION_YIELD NUMBER

Operation yield for an operation
CUMULATIVE_SCRAP_QUANTITY NUMBER

Total number of assemblies scrapped in previous operations
OPERATION_YIELD_ENABLED NUMBER

Indicates whether operation yield is to be considered by the cost processor
OPERATION_COMPLETED VARCHAR2 (1)
To indicated if the operation has been completed
OPERATION_COMPLETED_DISP VARCHAR2 (80) Yes Description to indicate operation has been completed
SHUTDOWN_TYPE VARCHAR2 (30)
Shutdown Type
SHUTDOWN_TYPE_DISP VARCHAR2 (80)
Shutdown Type description
X_POS NUMBER

X Coordinate position for the operation
Y_POS NUMBER

Y Coordinate position for the operation
LONG_DESCRIPTION VARCHAR2 (4000)
Long description
DISABLE_DATE DATE

Disable date
RECOMMENDED VARCHAR2 (1)
This column determine whether this operation is on recommended path or not
PROGRESS_PERCENTAGE NUMBER

This column stores the progress percentage for the current operation
Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      ORGANIZATION_ID
,      REPETITIVE_SCHEDULE_ID
,      OPERATION_SEQUENCE_ID
,      STANDARD_OPERATION_ID
,      OPERATION_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      LOCATION_ID
,      DESCRIPTION
,      SCHEDULED_QUANTITY
,      QUANTITY_IN_QUEUE
,      QUANTITY_RUNNING
,      QUANTITY_WAITING_TO_MOVE
,      QUANTITY_REJECTED
,      QUANTITY_SCRAPPED
,      QUANTITY_COMPLETED
,      FIRST_UNIT_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_START_DATE
,      LAST_UNIT_COMPLETION_DATE
,      PREVIOUS_OPERATION_SEQ_NUM
,      NEXT_OPERATION_SEQ_NUM
,      COUNT_POINT_TYPE
,      COUNT_POINT_TYPE_DISP
,      BACKFLUSH_FLAG
,      BACKFLUSH_FLAG_DISP
,      MINIMUM_TRANSFER_QUANTITY
,      DATE_LAST_MOVED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OPERATION_YIELD
,      CUMULATIVE_SCRAP_QUANTITY
,      OPERATION_YIELD_ENABLED
,      OPERATION_COMPLETED
,      OPERATION_COMPLETED_DISP
,      SHUTDOWN_TYPE
,      SHUTDOWN_TYPE_DISP
,      X_POS
,      Y_POS
,      LONG_DESCRIPTION
,      DISABLE_DATE
,      RECOMMENDED
,      PROGRESS_PERCENTAGE
FROM APPS.EAM_CFR_OPERATIONS_V;

Dependencies

[top of page]

APPS.EAM_CFR_OPERATIONS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_STANDARD_OPERATIONS
ViewMFG_LOOKUPS
SynonymWIP_OPERATIONS

APPS.EAM_CFR_OPERATIONS_V is not referenced by any database object