eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GMP_RSRC_UNAVAIL_DTL_V

Object Details

Object Name:	GMP_RSRC_UNAVAIL_DTL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMP.GMP_RSRC_UNAVAIL_DTL_V
Subobject Name:
Status:	VALID

View Type

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

Resource Unavailable Detail view

[View Source]

Columns

Name	Datatype	Length	Comments
EXCEPTION_ID	NUMBER		Surrogate Key
EXCEPTION_CODE	VARCHAR2	(6)	Code,User generated Description
RESOURCE_ID	NUMBER		Internal Id for resource FK to CR_RSRC_DTL
INSTANCE_ID	NUMBER		Surrogate key which uniquely indentifies the instance of a resource. This comes from the sequence GMP_RESOURCE_INSTANCES_S.
RESOURCE_UNITS	NUMBER		Number of Resources that are Not Available
FROM_DATE	DATE		Start Date-time of Unavailable time
TO_DATE	DATE		End Date-time of Unavailable time
WIP_ENTITY_ID	NUMBER
OP_SEQ	NUMBER
MAINT_ORG_ID	NUMBER
REASON_CODE	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(240)

Query Text

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


SELECT EXCEPTION_ID
,      EXCEPTION_CODE
,      RESOURCE_ID
,      INSTANCE_ID
,      RESOURCE_UNITS
,      FROM_DATE
,      TO_DATE
,      WIP_ENTITY_ID
,      OP_SEQ
,      MAINT_ORG_ID
,      REASON_CODE
,      DESCRIPTION
FROM APPS.GMP_RSRC_UNAVAIL_DTL_V;

Dependencies

[top of page]

APPS.GMP_RSRC_UNAVAIL_DTL_V references the following:

APPS: GMP_RSRC_EXCP_ASNMT; GMP_RSRC_EXCP_DTL; GMP_RSRC_EXCP_HDR; GMP_RSRC_UNAVAIL_MAN; MTL_TRANSACTION_REASONS

APPS.GMP_RSRC_UNAVAIL_DTL_V is referenced by following:

APPS: GMP_RSRC_AVL_PKG - show dependent code