[Home] [Help]
[Dependency Information]
VIEW: CSF.CSF_MD_POI_NM_ASGNS_AU#
Object Details
Object Name: | CSF_MD_POI_NM_ASGNS_AU# |
Object Type: | VIEW |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
POI_NM_ASGN_ID |
NUMBER |
(30) |
Yes |
|
NAME_TYPE |
VARCHAR2 |
(1) |
Yes |
|
NAME_ID |
NUMBER |
(30) |
Yes |
|
POI_ID |
NUMBER |
(30) |
Yes |
|
SECURITY_GROUP_ID |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT POI_NM_ASGN_ID
, NAME_TYPE
, NAME_ID
, POI_ID
, SECURITY_GROUP_ID
FROM CSF.CSF_MD_POI_NM_ASGNS_AU#;
Dependencies
[top of page]
CSF.CSF_MD_POI_NM_ASGNS_AU# references the following:
-
CSF
-
CSF_MD_POI_NM_ASGNS_AU
CSF.CSF_MD_POI_NM_ASGNS_AU# is referenced by following:
-
APPS
-
CSF_MD_POI_NM_ASGNS_AU