[Home] [Help] [Dependency Information]
Object Name: | CSF_RESOURCE |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
PREFERRED_RESOURCE_FLAG | VARCHAR2 | (1) | |
RESOURCE_INDEX | NUMBER |
|
|
DISTANCE | NUMBER |
|
|
RESOURCE_ID | NUMBER |
|
|
RESOURCE_TYPE | VARCHAR2 | (30) | |
RESOURCE_NAME | VARCHAR2 | (360) | |
PLANWIN_START | DATE |
|
|
PLANWIN_END | DATE |
|
|
RESOURCE_SOURCE | VARCHAR2 | (30) | |
TERR_ID | NUMBER |
|
|
TERR_NAME | VARCHAR2 | (240) | |
TERR_RANK | NUMBER |
|
|
RES_PREFERENCE | VARCHAR2 | (30) |
Name | Parameters | Result |
---|---|---|
CSF_RESOURCE |
SELF(CSF_RESOURCE) RESOURCE_ID(NUMBER) RESOURCE_TYPE(VARCHAR2) RESOURCE_NAME(VARCHAR2) |
CSF_RESOURCE |
CSF_RESOURCE |
SELF(CSF_RESOURCE) RESOURCE_INDEX(NUMBER) RESOURCE_ID(NUMBER) RESOURCE_TYPE(VARCHAR2) RESOURCE_NAME(VARCHAR2) RESOURCE_SOURCE(VARCHAR2) TERR_ID(NUMBER) TERR_NAME(VARCHAR2) TERR_RANK(NUMBER) PREFERRED_RESOURCE_FLAG(VARCHAR2) DISTANCE(NUMBER) PLANWIN_START(DATE) PLANWIN_END(DATE) |
CSF_RESOURCE |
CSF_RESOURCE |
SELF(CSF_RESOURCE) PREFERRED_RESOURCE_FLAG(VARCHAR2) RESOURCE_INDEX(NUMBER) DISTANCE(NUMBER) RESOURCE_ID(NUMBER) RESOURCE_TYPE(VARCHAR2) RESOURCE_NAME(VARCHAR2) PLANWIN_START(DATE) PLANWIN_END(DATE) |
CSF_RESOURCE |
CSF_RESOURCE |
SELF(CSF_RESOURCE) PREFERRED_RESOURCE_FLAG(VARCHAR2) RESOURCE_INDEX(NUMBER) DISTANCE(NUMBER) RESOURCE_ID(NUMBER) RESOURCE_TYPE(VARCHAR2) RESOURCE_NAME(VARCHAR2) PLANWIN_START(DATE) PLANWIN_END(DATE) RES_PREFERENCE(VARCHAR2) |
CSF_RESOURCE |
|
|
|