DBA Data[Home] [Help] [Dependency Information]

TABLE: CSF.CSF_MD_POI_NM_ASGNS

Object Details
Object Name: CSF_MD_POI_NM_ASGNS
Object Type: TABLE
Owner: CSF
FND Design Data: TableCSF.CSF_MD_POI_NM_ASGNS
Subobject Name:
Status: VALID


DEFINITOIN
A MD POI NAMES ASGN defines the M:M relationship between the MD NAME and the MD POI NAMES ASGN entity.
EXAMPLE
MISCELLANEOUS


Storage Details
Tablespace: TablespaceAPPS_TS_MEDIA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
POI_NM_ASGN_ID NUMBER (30) Yes The POI NM ASGN ID defines the unique identifier of the entity.
NAME_TYPE VARCHAR2 (1) Yes The NAME TYPE defines type of the name given to the POI.
NAME_ID NUMBER (30) Yes The NAME ID defines the unique identifier of the name.
POI_ID NUMBER (30) Yes A unique identifier for the POI.
SECURITY_GROUP_ID NUMBER

Identifier used for running in hosted mode.
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;

Dependencies

[top of page]

CSF.CSF_MD_POI_NM_ASGNS does not reference any database object

CSF.CSF_MD_POI_NM_ASGNS is referenced by following:

SchemaAPPS
Materialized ViewCSF_MD_POIS_MAT_V
SynonymCSF_MD_POI_NM_ASGNS