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

TABLE: AX.AX_POSTING_CTRL

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


This table stores marks used during the posting process. It includes
a row for every application and set of books.
The column STATUS may have the following values:
- S: Translate Events started
- T: Events Translated
- P: AP Posting terminated
- X: Transfer to GL terminated
This table should not be accessed directly but through the package
AX_POSTING_CTRL_PKG.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: AX_POSTING_CTRL_PK
  1. ColumnAPPLICATION_ID
  2. ColumnSET_OF_BOOKS_ID
Indexes
Index Type Uniqueness Tablespace Column
AX_POSTING_CTRL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnSET_OF_BOOKS_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Yes Application identifier
SET_OF_BOOKS_ID NUMBER
Yes Set of books 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
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
STATUS VARCHAR2 (1)
Status of the posting process
Query Text

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


SELECT APPLICATION_ID
,      SET_OF_BOOKS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS
FROM AX.AX_POSTING_CTRL;

Dependencies

[top of page]

AX.AX_POSTING_CTRL does not reference any database object

AX.AX_POSTING_CTRL is referenced by following:

SchemaAPPS
SynonymAX_POSTING_CTRL