[Home] [Help]
[Dependency Information]
TABLE: APPS.CSF_MD_POIS_MAT_V
Object Details
| Object Name: | CSF_MD_POIS_MAT_V |
| Object Type: | TABLE |
| Owner: | APPS |
| FND Design Data: | FND.CSF_MD_POIS_MAT_V
|
|---|
| Subobject Name: | |
| Status: | VALID |
Storage Details
| Tablespace: | APPS_TS_SUMMARY |
| PCT Free: | 10 |
| PCT Used: | |
Indexes
| Index |
Type |
Uniqueness |
Tablespace |
Column |
|
SYS_IL0000448004C00009$$
|
LOB
|
UNIQUE
|
APPS_TS_SUMMARY
|
|
|
SYS_IL0000448004C00010$$
|
LOB
|
UNIQUE
|
APPS_TS_SUMMARY
|
|
Columns
| Name |
Datatype |
Length |
Mandatory |
Comments |
| POI_ID |
NUMBER |
(30) |
|
|
| FEATURE_CODE |
NUMBER |
|
|
|
| GEOMETRY |
SDO_GEOMETRY |
(1) |
|
|
| NAME |
VARCHAR2 |
(70) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT POI_ID
, FEATURE_CODE
, GEOMETRY
, NAME
FROM APPS.CSF_MD_POIS_MAT_V;
Dependencies
[top of page]
APPS.CSF_MD_POIS_MAT_V references the following:
-
MDSYS
-
SDO_ELEM_INFO_ARRAY
-
SDO_GEOMETRY
-
SDO_ORDINATE_ARRAY
-
SYS
-
STANDARD
- show dependent code
APPS.CSF_MD_POIS_MAT_V is referenced by following:
-
APPS
-
CSF_MD_POIS_MAT_V