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

VIEW: APPS.GMP_EAM_JOBS_RESOURCES_V

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

View Type

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


View for eAM jobs on OPM resources


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database row identifier
RESOURCE_ID NUMBER (10) Yes Resource ID
DEPARTMENT_ID NUMBER

Owning department id
WIP_ENTITY_ID NUMBER (10) Yes Job Id
WIP_ENTITY_NAME VARCHAR2 (32) Yes Job Number
DESCRIPTION VARCHAR2 (32) Yes Job Description
SCHEDULED_START_DATE DATE
Yes Start Date
SCHEDULED_COMPLETION_DATE DATE
Yes Completion date
STATUS_TYPE NUMBER (5) Yes Status type
STATUS_TYPE_MEANING VARCHAR2 (80) Yes Meaning of the status
JOB_TYPE NUMBER (5) Yes Job type
JOB_TYPE_MEANING VARCHAR2 (5)
Meaning for job type
CLASS_CODE VARCHAR2 (0)
Class code
REBUILD_ITEM_ID NUMBER

Rebuild Item Id
ENTITY_TYPE NUMBER

Entity Type
ENTITY_TYPE_CODE VARCHAR2 (0)
Entity Type Code
Query Text

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


SELECT ROW_ID
,      RESOURCE_ID
,      DEPARTMENT_ID
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      DESCRIPTION
,      SCHEDULED_START_DATE
,      SCHEDULED_COMPLETION_DATE
,      STATUS_TYPE
,      STATUS_TYPE_MEANING
,      JOB_TYPE
,      JOB_TYPE_MEANING
,      CLASS_CODE
,      REBUILD_ITEM_ID
,      ENTITY_TYPE
,      ENTITY_TYPE_CODE
FROM APPS.GMP_EAM_JOBS_RESOURCES_V;

Dependencies

[top of page]

APPS.GMP_EAM_JOBS_RESOURCES_V references the following:

SchemaAPPS
SynonymCR_RSRC_DTL
ViewGEM_LOOKUPS
SynonymGME_BATCH_HEADER
SynonymGME_BATCH_STEPS
SynonymGME_BATCH_STEP_ACTIVITIES
SynonymGME_BATCH_STEP_RESOURCES
APPS.GMP_EAM_JOBS_RESOURCES_V is referenced by following:

SchemaAPPS
ViewMTL_EAM_JOBS_RESOURCES_V