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

VIEW: APPS.WIP_BIS_PROD_VAL_EMP_V

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

View Type

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


Shows the average production per employee in an inventory organization.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization Name
LEGAL_ENTITY NUMBER

Legal Entity
QUANTITY NUMBER

Quantity
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
ITEM_PRICE NUMBER

Item Price
NUM_OF_EMP NUMBER

Number of Employees
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      LEGAL_ENTITY
,      QUANTITY
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      ITEM_PRICE
,      NUM_OF_EMP
FROM APPS.WIP_BIS_PROD_VAL_EMP_V;

Dependencies

[top of page]

APPS.WIP_BIS_PROD_VAL_EMP_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageMRP_EPI - show dependent code
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymORG_ACCT_PERIODS
ViewORG_ORGANIZATION_DEFINITIONS
PL/SQL PackageWIP_BIS_COMMON - show dependent code

APPS.WIP_BIS_PROD_VAL_EMP_V is not referenced by any database object