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


TABLE: GML.OP_UPDT_BAL_WK

Object Details
Object Name: OP_UPDT_BAL_WK
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.OP_UPDT_BAL_WK
Subobject Name:
Status: VALID


This table is used by the " Update Customer Balance Report" to retrieve data that it needs to process.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OP_UPDT_BALI1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSESSION_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER (15) Yes Users session id
CUST_NO VARCHAR2 (32) Yes Customer Number
CUST_NAME VARCHAR2 (70) Yes Customer Name
ERROR_MESSAGE VARCHAR2 (250) Yes Error message text
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
Query Text

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


SELECT SESSION_ID
,      CUST_NO
,      CUST_NAME
,      ERROR_MESSAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM GML.OP_UPDT_BAL_WK;

Dependencies

[top of page]

GML.OP_UPDT_BAL_WK does not reference any database object

GML.OP_UPDT_BAL_WK is referenced by following:

SchemaAPPS
SynonymOP_UPDT_BAL_WK