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


TABLE: AP.AP_RECON_DISTRIBUTIONS_ALL

Object Details
Object Name: AP_RECON_DISTRIBUTIONS_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_RECON_DISTRIBUTIONS_ALL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_RECON_DISTRIBUTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCHECK_ID
AP_RECON_DISTRIBUTIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPOSTED_FLAG
AP_RECON_DISTRIBUTIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnACCRUAL_POSTED_FLAG
AP_RECON_DISTRIBUTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCASH_POSTED_FLAG
AP_RECON_DISTRIBUTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnREVERSAL_FLAG
AP_RECON_DISTRIBUTIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnACCOUNTING_DATE
Columns
Name Datatype Length Mandatory Comments
CHECK_ID NUMBER (15) Yes Payment identifier
CODE_COMBINATION_ID NUMBER (15) Yes Accounting flexfield identifier
AMOUNT NUMBER
Yes Amount
BASE_AMOUNT NUMBER

Amount in functional currency
LINE_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Type of reconciliation distribution ('UNCLEARED CASH', 'CASH', 'GAIN', 'LOSS', 'CHARGES' or 'ERRORS')
POSTED_FLAG VARCHAR2 (1) Yes Flag that indicates if distribution has been posted (Y or N) or selected for posting (S)
ACCRUAL_POSTED_FLAG VARCHAR2 (1) Yes Flag that indicates if distribution has been posted to accrual set of books (Y or N)
CASH_POSTED_FLAG VARCHAR2 (1) Yes Flag that indicates if distribution has been posted to cash set of books (Y or N)
ACCOUNTING_DATE DATE
Yes Accounting date of transaction
PERIOD_NAME VARCHAR2 (15) Yes Accounting period name of transaction
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
REVERSAL_FLAG VARCHAR2 (1) Yes Flag that indicates if the distribution results from a clearing reversal
ORG_ID NUMBER (15)
Organization identifier
R115_UPG VARCHAR2 (15)
Query Text

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


SELECT CHECK_ID
,      CODE_COMBINATION_ID
,      AMOUNT
,      BASE_AMOUNT
,      LINE_TYPE_LOOKUP_CODE
,      POSTED_FLAG
,      ACCRUAL_POSTED_FLAG
,      CASH_POSTED_FLAG
,      ACCOUNTING_DATE
,      PERIOD_NAME
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      REVERSAL_FLAG
,      ORG_ID
,      R115_UPG
FROM AP.AP_RECON_DISTRIBUTIONS_ALL;

Dependencies

[top of page]

AP.AP_RECON_DISTRIBUTIONS_ALL does not reference any database object

AP.AP_RECON_DISTRIBUTIONS_ALL is referenced by following:

SchemaAP
ViewAP_RECON_DISTRIBUTIONS_ALL#