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

VIEW: APPS.ENI_RESOURCE_V

Object Details
Object Name: ENI_RESOURCE_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view contains Discrete and Process Manufacturing resources.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (122)
Id
VALUE VARCHAR2 (32)
The concatenated value of Resource Group and Organization Code
RESOURCE_ID NUMBER

Resource identifier
RESOURCE_CODE VARCHAR2 (16)
Resource code
BOM_RESOURCE_TYPE NUMBER

Resource type
ORGANIZATION_ID NUMBER

Organization identifier
DEPARTMENT_ID VARCHAR2 (40)
Department identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department code
RESOURCE_GROUP VARCHAR2 (30)
Resource group
UNIT_OF_MEASURE VARCHAR2 (3)
Unit of measure
DISABLE_DATE DATE

Disable date
DEPARTMENT_FK VARCHAR2 (42)
Foreign key to department
RESOURCE_GROUP_FK VARCHAR2 (32)
Resource group foreign key
Query Text

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


SELECT ID
,      VALUE
,      RESOURCE_ID
,      RESOURCE_CODE
,      BOM_RESOURCE_TYPE
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_GROUP
,      UNIT_OF_MEASURE
,      DISABLE_DATE
,      DEPARTMENT_FK
,      RESOURCE_GROUP_FK
FROM APPS.ENI_RESOURCE_V;

Dependencies

[top of page]

APPS.ENI_RESOURCE_V references the following:

SchemaAPPS
TableENI_RES_5_MV
SynonymMTL_PARAMETERS

APPS.ENI_RESOURCE_V is not referenced by any database object