[Home] [Help] [Dependency Information]
Object Name: | MSC_RESOURCE_PARAMETERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
ORGANIZATION_ID | NUMBER | Yes | Organization ID | |
ORGANIZATION_CODE | VARCHAR2 | (7) | Organization Code | |
SR_INSTANCE_ID | NUMBER | Yes | Sr Instance ID | |
DEPARTMENT_ID | NUMBER | Yes | Department ID | |
DEPARTMENT_CODE | VARCHAR2 | (10) | Department Code | |
RESOURCE_ID | NUMBER | Yes | Resource ID | |
RESOURCE_CODE | VARCHAR2 | (16) | Resource Code | |
RESOURCE_DESCRIPTION | VARCHAR2 | (240) | Resource Description | |
RESOURCE_TYPE_ID | NUMBER | Yes | Resource Type ID | |
RESOURCE_TYPE | VARCHAR2 | (4000) | Resource Type | |
BATCHABLE | NUMBER | Batchable | ||
AVAILABLE_SPOTS | NUMBER | Availbale Spots | ||
CRO | NUMBER | CRO | ||
MIN_CYCLE_TIME | NUMBER | Min Cycle Time | ||
MIN_CYCLE_TIME_UNIT_ID | NUMBER | Min Cycle Time Unit ID | ||
MIN_CYCLE_TIME_UNIT | VARCHAR2 | (4000) | Min Cycle Time Unit | |
MIN_CHANGE_BET_CYCLES | NUMBER | Min Change Bet Cycles | ||
OFFLOAD_PERCENTAGE | NUMBER | Offload Percentage | ||
OFFLOAD_WINDOW | NUMBER | Offload Window | ||
OFFLOAD_WINDOW_UNIT_ID | NUMBER | Offload Window Unit ID | ||
OFFLOAD_WINDOW_UNIT | VARCHAR2 | (4000) | Offload Window Unit | |
INV_RELEASE_INTERVAL | NUMBER | Inv Release Interval | ||
INV_REL_INTERVAL_UNIT_ID | NUMBER | Inv Rel Interval Unit ID | ||
INV_REL_INTERVAL_UNIT | VARCHAR2 | (4000) | Inv Rel Interval Unit | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column | ||
CREATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, SR_INSTANCE_ID
, DEPARTMENT_ID
, DEPARTMENT_CODE
, RESOURCE_ID
, RESOURCE_CODE
, RESOURCE_DESCRIPTION
, RESOURCE_TYPE_ID
, RESOURCE_TYPE
, BATCHABLE
, AVAILABLE_SPOTS
, CRO
, MIN_CYCLE_TIME
, MIN_CYCLE_TIME_UNIT_ID
, MIN_CYCLE_TIME_UNIT
, MIN_CHANGE_BET_CYCLES
, OFFLOAD_PERCENTAGE
, OFFLOAD_WINDOW
, OFFLOAD_WINDOW_UNIT_ID
, OFFLOAD_WINDOW_UNIT
, INV_RELEASE_INTERVAL
, INV_REL_INTERVAL_UNIT_ID
, INV_REL_INTERVAL_UNIT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM APPS.MSC_RESOURCE_PARAMETERS_V;
APPS.MSC_RESOURCE_PARAMETERS_V is not referenced by any database object
|
|
|