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

VIEW: APPS.CR_RSRC_MST_VL

Object Details
Object Name: CR_RSRC_MST_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMP.CR_RSRC_MST_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Resource Master view


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RESOURCE_CLASS VARCHAR2 (8)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
TRANS_CNT NUMBER (22)
DELETE_MARK NUMBER (22) Yes
TEXT_CODE NUMBER (10)
LAST_UPDATE_LOGIN NUMBER (15)
MIN_CAPACITY NUMBER

MAX_CAPACITY NUMBER

CAPACITY_CONSTRAINT NUMBER (5)
CAPACITY_UOM VARCHAR2 (4)
RESOURCES VARCHAR2 (16) Yes
STD_USAGE_UM VARCHAR2 (4)
COST_CMPNTCLS_ID NUMBER (10) Yes
CAPACITY_TOLERANCE NUMBER

Resource Capacity Tolerance
UTILIZATION NUMBER

Indicates the resource utilization.
EFFICIENCY NUMBER

Indicates the resource efficiency.
RESOURCE_DESC VARCHAR2 (240) Yes
STD_USAGE_UOM VARCHAR2 (3)
Standard Usage UOM
CAPACITY_UM VARCHAR2 (3)
Capacity UM
Query Text

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


SELECT ROW_ID
,      RESOURCE_CLASS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      MIN_CAPACITY
,      MAX_CAPACITY
,      CAPACITY_CONSTRAINT
,      CAPACITY_UOM
,      RESOURCES
,      STD_USAGE_UM
,      COST_CMPNTCLS_ID
,      CAPACITY_TOLERANCE
,      UTILIZATION
,      EFFICIENCY
,      RESOURCE_DESC
,      STD_USAGE_UOM
,      CAPACITY_UM
FROM APPS.CR_RSRC_MST_VL;

Dependencies

[top of page]

APPS.CR_RSRC_MST_VL references the following:

SchemaAPPS
SynonymCR_RSRC_MST_B
SynonymCR_RSRC_MST_TL
APPS.CR_RSRC_MST_VL is referenced by following:

SchemaAPPS
SynonymCR_RSRC_MST
TriggerCR_RSRC_MST_DL
ViewMTH_SRC_EQUIP_ENTITIES_V
ViewMTH_SRC_EQUIP_HIERARCHY_V
ViewMTH_SRC_RESOURCES_V