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

TABLE: IGS.IGS_FI_P_SA_NOTES

Object Details
Object Name: IGS_FI_P_SA_NOTES
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_FI_P_SA_NOTES
Subobject Name:
Status: VALID


Contains any textual notes for a subaccount and a person context.This tracks the notes with an effective date.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_P_SA_NOTES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_SA_NOTES_ID
IGS_FI_P_SA_NOTES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
ColumnEFFECTIVE_DATE
ColumnREFERENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
PARTY_SA_NOTES_ID NUMBER (15) Yes Sequence generated number - Primary Key of the table
PARTY_ID NUMBER (15) Yes Party ID - Person identifier for which notes being entered
SUBACCOUNT_ID NUMBER (15)
OBSOLETE. Sub Account ID that this note belongs to
EFFECTIVE_DATE DATE
Yes Effective date for the note
REFERENCE_NUMBER NUMBER
Yes Reference number link to derive text for the note
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
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
Query Text

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


SELECT PARTY_SA_NOTES_ID
,      PARTY_ID
,      SUBACCOUNT_ID
,      EFFECTIVE_DATE
,      REFERENCE_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM IGS.IGS_FI_P_SA_NOTES;

Dependencies

[top of page]

IGS.IGS_FI_P_SA_NOTES does not reference any database object

IGS.IGS_FI_P_SA_NOTES is referenced by following:

SchemaAPPS
SynonymIGS_FI_P_SA_NOTES