[Home] [Help] [Dependency Information]
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 |
MultiLingual view (a language resolved view of the data.)
Resource Unavailable Detail view
Name | Datatype | Length | Mandatory | 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) |
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;
|
|
|