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

TABLE: AMW.AMW_FIN_PROC_CERT_RELAN

Object Details
Object Name: AMW_FIN_PROC_CERT_RELAN
Object Type: TABLE
Owner: AMW
FND Design Data: TableAMW.AMW_FIN_PROC_CERT_RELAN
Subobject Name:
Status: VALID


Associates with each financial statement certification one or more process certifications.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_FIN_PROC_CERT_RELAN_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFIN_PROC_CERT_ID
AMW_FIN_PROC_CERT_RELAN_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFIN_STMT_CERT_ID
ColumnPROC_CERT_ID
Columns
Name Datatype Length Mandatory Comments
FIN_PROC_CERT_ID NUMBER
Yes Entity Identifier
FIN_STMT_CERT_ID NUMBER
Yes Identifies a financial statement certification.
PROC_CERT_ID NUMBER
Yes Identifier a process certification.
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
SECURITY_GROUP_ID NUMBER

Standard Column
OBJECT_VERSION_NUMBER NUMBER

Standard Column
END_DATE DATE

End date for the business certification relation
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FIN_PROC_CERT_ID
,      FIN_STMT_CERT_ID
,      PROC_CERT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      END_DATE
FROM AMW.AMW_FIN_PROC_CERT_RELAN;

Dependencies

[top of page]

AMW.AMW_FIN_PROC_CERT_RELAN does not reference any database object

AMW.AMW_FIN_PROC_CERT_RELAN is referenced by following:

SchemaAPPS
SynonymAMW_FIN_PROC_CERT_RELAN