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

VIEW: APPS.WIP_WS_PTPKPI_AGG_V

Object Details
Object Name: WIP_WS_PTPKPI_AGG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_WS_PTPKPI_AGG_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
ORGANIZATION_ID NUMBER

Organization identifier
DEPARTMENT_ID NUMBER

Department identifier
WIP_ENTITY_ID NUMBER

WIP Job identifier
OPERATION_SEQ_NUM NUMBER

Operation Sequence Number
SHIFT_ID VARCHAR2 (100)
Shift identifier
PLANNED_QTY NUMBER

Planned quantity
MOVED_AGAINST_PLANNED_QTY NUMBER

Moved against planned quantity
MOVED_AGAINST_UNPLANNED_QTY NUMBER

Moved against unplanned quantity
SCRAPPED_QTY NUMBER

Scrapped quantity
REJECTED_QTY NUMBER

Rejected quantity
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary UOM code
OP_LEAD_TIME NUMBER

Operation lead time
SHIFT_START_TIME DATE

Shift start time
Query Text

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


SELECT ORGANIZATION_ID
,      DEPARTMENT_ID
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      SHIFT_ID
,      PLANNED_QTY
,      MOVED_AGAINST_PLANNED_QTY
,      MOVED_AGAINST_UNPLANNED_QTY
,      SCRAPPED_QTY
,      REJECTED_QTY
,      PRIMARY_UOM_CODE
,      OP_LEAD_TIME
,      SHIFT_START_TIME
FROM APPS.WIP_WS_PTPKPI_AGG_V;

Dependencies

[top of page]

APPS.WIP_WS_PTPKPI_AGG_V references the following:

SchemaAPPS
SynonymWIP_WS_PTPKPI_ACTUAL
SynonymWIP_WS_PTPKPI_PLAN

APPS.WIP_WS_PTPKPI_AGG_V is not referenced by any database object