[Home] [Help]
[Dependency Information]
VIEW: CSF.CSF_LF_POSTCODES#
Object Details
Object Name: | CSF_LF_POSTCODES# |
Object Type: | VIEW |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
POSTAL_CODE_ID |
NUMBER |
(30) |
Yes |
|
POSTAL_CODE |
VARCHAR2 |
(240) |
Yes |
|
COUNTRY_CODE |
VARCHAR2 |
(240) |
Yes |
|
POSTAL_CODE_LOCUS |
SDO_GEOMETRY |
(64) |
|
|
SECURITY_GROUP_ID |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT POSTAL_CODE_ID
, POSTAL_CODE
, COUNTRY_CODE
, POSTAL_CODE_LOCUS
, SECURITY_GROUP_ID
FROM CSF.CSF_LF_POSTCODES#;
Dependencies
[top of page]
CSF.CSF_LF_POSTCODES# references the following:
-
CSF
-
CSF_LF_POSTCODES
-
MDSYS
-
SDO_GEOMETRY
-
SYS
-
STANDARD
- show dependent code
CSF.CSF_LF_POSTCODES# is referenced by following:
-
APPS
-
CSF_LF_POSTCODES