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

TABLE: AX.AX_SUBLEDGERS

Object Details
Object Name: AX_SUBLEDGERS
Object Type: TABLE
Owner: AX
FND Design Data: TableAX.AX_SUBLEDGERS
Subobject Name:
Status: VALID


This table stores information that depend on the
application. It includes a row for every installed subledger
application.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_SUBLEDGERS_PK
  1. ColumnAPPLICATION_ID
Indexes
Index Type Uniqueness Tablespace Column
AX_SUBLEDGERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
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
JE_SOURCE_NAME VARCHAR2 (25) Yes Journal entry source name
JE_CATEGORY_NAME VARCHAR2 (25) Yes Journal entry category name
Query Text

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


SELECT APPLICATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
FROM AX.AX_SUBLEDGERS;

Dependencies

[top of page]

AX.AX_SUBLEDGERS does not reference any database object

AX.AX_SUBLEDGERS is referenced by following:

SchemaAPPS
SynonymAX_SUBLEDGERS