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

TABLE: AMW.AMW_FIN_STMNT_SELECTION

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


Stores the Financial Statements that are selected for importing into ICM while the Financial Statement Import function is executed


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_FIN_STMNT_SELECTION_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUN_ID
ColumnFINANCIAL_STATEMENT_ID
Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER
Yes A Batch Number to Group the Statements that are selected during an Import
FINANCIAL_STATEMENT_ID NUMBER (15) Yes The ID of the Financial Statement that is selected for importing into ICM
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

This column is used for optimistic locking
Query Text

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


SELECT RUN_ID
,      FINANCIAL_STATEMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM AMW.AMW_FIN_STMNT_SELECTION;

Dependencies

[top of page]

AMW.AMW_FIN_STMNT_SELECTION does not reference any database object

AMW.AMW_FIN_STMNT_SELECTION is referenced by following:

SchemaAPPS
SynonymAMW_FIN_STMNT_SELECTION