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

VIEW: APPS.WIP_BIS_PRODUCTIVITIES_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


Shows the efficiency for each hour-based resource in an
organization on a given date. It contains the standard hours and the
actual hours applied for a resource in a particular
department at a particular operation sequence number and for
a particular transaction date.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
LEGAL_ENTITY NUMBER

Legal Entity
TRANSACTION_DATE DATE

Transaction Date
PERIOD_SET_NAME VARCHAR2 (15) Yes Period Set Name
PERIOD_NAME VARCHAR2 (15) Yes Period Name
PERIOD_START_DATE DATE
Yes Period Start Date
PERIOD_END_DATE DATE
Yes Period End Date
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
RESOURCE_CODE VARCHAR2 (10)
Resource Code
APPLIED_HOURS NUMBER

Applied Hours
STANDARD_HOURS NUMBER

Standard Hours
PRODUCTIVITY_PERCENT NUMBER

Productivity in Percentage
Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_NAME
,      LEGAL_ENTITY
,      TRANSACTION_DATE
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      DEPARTMENT_CODE
,      RESOURCE_CODE
,      APPLIED_HOURS
,      STANDARD_HOURS
,      PRODUCTIVITY_PERCENT
FROM APPS.WIP_BIS_PRODUCTIVITIES_V;

Dependencies

[top of page]

APPS.WIP_BIS_PRODUCTIVITIES_V references the following:

SchemaAPPS
SynonymORG_ACCT_PERIODS
SynonymWIP_BIS_PROD_INDICATORS

APPS.WIP_BIS_PRODUCTIVITIES_V is not referenced by any database object