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

TABLE: GMF.GL_MEMO_STA

Object Details
Object Name: GL_MEMO_STA
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.GL_MEMO_STA
Subobject Name:
Status: VALID


Internal Table used by the AR Update Process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_MEMO_STA_IDX NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes Cutomer Transaction Identifier
UPDATED_FLAG VARCHAR2 (1) Yes Update Indicator
INTERFACE_DATE DATE

Date on which memo is processed by credit/debit memo data synch program
Query Text

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


SELECT CUSTOMER_TRX_ID
,      UPDATED_FLAG
,      INTERFACE_DATE
FROM GMF.GL_MEMO_STA;

Dependencies

[top of page]

GMF.GL_MEMO_STA does not reference any database object

GMF.GL_MEMO_STA is referenced by following:

SchemaAPPS
SynonymGL_MEMO_STA