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

VIEW: APPS.PMITS_OPERATION_RESOURCES_V

Object Details
Object Name: PMITS_OPERATION_RESOURCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMITS_OPERATION_RESOURCES_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCES CHAR (3)
Resource
RESOURCE_DESC CHAR (3)
Resource Description
RESOURCE_CLASS CHAR (3)
Resource Class
OPRN_LINE_ID NUMBER

Operation Line ID
RSRC_UOM CHAR (3)
Resource UOM
PROCESS_QTY NUMBER

Process Quantity
PROCESS_UOM CHAR (3)
UOM for Process Quantity
RESOURCE_USAGE NUMBER

Resource Usage Amount
USAGE_UM CHAR (3)
UOM for Resource Usage
RESOURCE_COUNT NUMBER

Resource Count
PRIM_RSRC_IND NUMBER

Primary Resource Indicator
PRIM_RSRC_IND_DISP CHAR (3)
SCALE_TYPE NUMBER

Scale Type
SCALE_TYPE_DISP CHAR (3)
COST_CMPNTCLS_ID NUMBER

Cost Component Class ID
COST_CMPNTCLS_CODE CHAR (3)
Cost Component Class Code
COST_CMPNTCLS_DESC CHAR (3)
Cost Component Class Description
COST_ANALYSIS_CODE CHAR (3)
Cost Analysis Code
COST_ANALYSIS_DESC CHAR (3)
Cost Analysis Description
OFFSET_INTERVAL NUMBER

Offset Interval
DELETE_MARK NUMBER

Delete Mark
TEXT_CODE NUMBER

Text Code
MIN_CAPACITY NUMBER

Minimum Capacity
MAX_CAPACITY NUMBER

Maximum Capacity
CAPACITY_UOM CHAR (3)
Capacity UOM
PROCESS_PARAMETER_1 CHAR (3)
Process Parameter 1
PROCESS_PARAMETER_2 CHAR (3)
Process Parameter 2
PROCESS_PARAMETER_3 CHAR (3)
Process Parameter 3
PROCESS_PARAMETER_4 CHAR (3)
Process Parameter 4
PROCESS_PARAMETER_5 CHAR (3)
Process Parameter 5
Query Text

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


SELECT RESOURCES
,      RESOURCE_DESC
,      RESOURCE_CLASS
,      OPRN_LINE_ID
,      RSRC_UOM
,      PROCESS_QTY
,      PROCESS_UOM
,      RESOURCE_USAGE
,      USAGE_UM
,      RESOURCE_COUNT
,      PRIM_RSRC_IND
,      PRIM_RSRC_IND_DISP
,      SCALE_TYPE
,      SCALE_TYPE_DISP
,      COST_CMPNTCLS_ID
,      COST_CMPNTCLS_CODE
,      COST_CMPNTCLS_DESC
,      COST_ANALYSIS_CODE
,      COST_ANALYSIS_DESC
,      OFFSET_INTERVAL
,      DELETE_MARK
,      TEXT_CODE
,      MIN_CAPACITY
,      MAX_CAPACITY
,      CAPACITY_UOM
,      PROCESS_PARAMETER_1
,      PROCESS_PARAMETER_2
,      PROCESS_PARAMETER_3
,      PROCESS_PARAMETER_4
,      PROCESS_PARAMETER_5
FROM APPS.PMITS_OPERATION_RESOURCES_V;

Dependencies

[top of page]

APPS.PMITS_OPERATION_RESOURCES_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.PMITS_OPERATION_RESOURCES_V is not referenced by any database object