[Home] [Help] [Dependency Information]
Object Name: | AR_CCID_CORRECTIONS_ALL |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_CCID_CORRECTIONS_ALL |
Subobject Name: | |
Status: | VALID |
The AR_CCID_CORRECTIONS_ALL table stores the invalid or inactive code combinations that Oracle Receivables detects during the GL Transfer process. Each time the GL Transfer process is run, Receivables purges and rebuilds all table contents
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_CCID_CORRECTIONS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
SOURCE_TABLE
DISTRIBUTION_ID |
AR_CCID_CORRECTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
SUBMISSION_ID
SOURCE_TABLE DISTRIBUTION_TYPE PARENT_ID |
AR_CCID_CORRECTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
SUBMISSION_ID
SOURCE_TABLE DISTRIBUTION_TYPE DISTRIBUTION_ID |
AR_CCID_CORRECTIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
SOURCE_TABLE
DISTRIBUTION_TYPE CODE_COMBINATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISTRIBUTION_TYPE | VARCHAR2 | (20) | Yes | ACCOUNT_CLASS or SOURCE_TYPE of postable accounting distribution |
CATEGORY_TYPE | VARCHAR2 | (20) | Yes | Identifies the type of transaction or activity that originated the accounting entry |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | Account identifier (current) |
NEW_CODE_COMBINATION_ID | NUMBER | (15) | Account identifier (corrected) | |
SUBMISSION_ID | NUMBER | (15) | Identifier for the batch processing of corrections | |
ORG_ID | NUMBER | (15) | Operating Unit identifier | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | (15) | Standard Who column | |
DISTRIBUTION_ID | NUMBER | (15) | Yes | For SOURCE_TABLE = GLD, contains CUST_TRX_LINE_GL_DIST_ID. For other SOURCE_TABLE values, contains AR_DISTRIBUTIONS_ALL.LINE_ID. |
SOURCE_TABLE | VARCHAR2 | (10) | Yes | Identifies table where accounting originated from. Values may include GLD, RA, CRH, MCD, TH, and ADJ. |
PARENT_ID | NUMBER | (15) | Yes | For SOURCE_TABLE = GLD, contains CUSTOMER_TRX_ID. For other SOURCE_TABLE values, contains AR_DISTRIBUTIONS_ALL.SOURCE_ID. |
GL_DATE | DATE | General Ledger date |
Cut, paste (and edit) the following text to query this object:
SELECT DISTRIBUTION_TYPE
, CATEGORY_TYPE
, CODE_COMBINATION_ID
, NEW_CODE_COMBINATION_ID
, SUBMISSION_ID
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, DISTRIBUTION_ID
, SOURCE_TABLE
, PARENT_ID
, GL_DATE
FROM AR.AR_CCID_CORRECTIONS_ALL;
AR.AR_CCID_CORRECTIONS_ALL does not reference any database object
AR.AR_CCID_CORRECTIONS_ALL is referenced by following:
|
|
|