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

VIEW: APPS.WIP_BIS_UTZ_CAT_V

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

View Type

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


Shows Utilization for every hour-based resource in an organization
on a given date.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER

Set of Books Identifier
LEDGER_NAME VARCHAR2 (30)
Set of Books Name
LEGAL_ENTITY_ID NUMBER

Legal Entity Identifier
LEGAL_ENTITY_NAME VARCHAR2 (240)
Legal Entity Name
OPERATING_UNIT_ID NUMBER

Operating Unit Identifier
OPERATING_UNIT_NAME VARCHAR2 (240)
Operating Unit Name
ORGANIZATION_ID NUMBER

Organization Identifier
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
DEPARTMENT_ID NUMBER

Department Identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
RESOURCE_ID NUMBER

Resource Identifier
RESOURCE_CODE VARCHAR2 (10)
Resource Code
LOCATION_ID NUMBER

Location Identifier
AREA_CODE VARCHAR2 (30)
Area Code
AREA_NAME VARCHAR2 (80)
Area Name
COUNTRY_CODE VARCHAR2 (60)
Country Code
COUNTRY_NAME VARCHAR2 (80)
Country Name
REGION_CODE VARCHAR2 (30)
Region Code
REGION_NAME VARCHAR2 (80)
Region Name
TRANSACTION_DATE DATE

Transaction Date
CATEGORY_ID NUMBER

Category Identifier
CATEGORY_NAME VARCHAR2 (163)
Category Name
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
INVENTORY_ITEM_NAME VARCHAR2 (40)
Inventory Item Name
ACTUAL_HOURS NUMBER

Actual Hours
AVAILABLE_HOURS NUMBER

Available Hours
PERIOD_SET_NAME VARCHAR2 (15)
Period Set Name
PERIOD_YEAR VARCHAR2 (15)
Period Year
PERIOD_QUARTER VARCHAR2 (15)
Period Quarter
PERIOD_MONTH VARCHAR2 (15)
Period Month
Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_ID
,      RESOURCE_CODE
,      LOCATION_ID
,      AREA_CODE
,      AREA_NAME
,      COUNTRY_CODE
,      COUNTRY_NAME
,      REGION_CODE
,      REGION_NAME
,      TRANSACTION_DATE
,      CATEGORY_ID
,      CATEGORY_NAME
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      ACTUAL_HOURS
,      AVAILABLE_HOURS
,      PERIOD_SET_NAME
,      PERIOD_YEAR
,      PERIOD_QUARTER
,      PERIOD_MONTH
FROM APPS.WIP_BIS_UTZ_CAT_V;

Dependencies

[top of page]

APPS.WIP_BIS_UTZ_CAT_V references the following:

SchemaAPPS
SynonymWIP_BIS_PROD_INDICATORS
APPS.WIP_BIS_UTZ_CAT_V is referenced by following:

SchemaAPPS
Package BodyWIP_BIS_UTZ_ALERT - show dependent code