[Home] [Help] [Dependency Information]
Object Name: | PSA_XLA_AE_LINES_LOGS |
---|---|
Object Type: | TABLE |
Owner: | PSA |
Subobject Name: | |
Status: | VALID |
This table stores information from xla_ae_lines_gt which would have otherwise got lost after session expiry. The table is populated if the following conditions are met:
1. Budgetary Control Enabled.
2. Profile 'PSA Debug Mode' is set to Yes.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AE_HEADER_ID | NUMBER | (15) | XLA journal entry header defining column | |
AE_LINE_NUM | NUMBER | (15) | XLA journal entry line defining column | |
SOURCE_DISTRIBUTION_ID_CHAR_1 | VARCHAR2 | (240) | Source Reference Column | |
SOURCE_DISTRIBUTION_ID_CHAR_2 | VARCHAR2 | (240) | Source Reference Column | |
SOURCE_DISTRIBUTION_ID_CHAR_3 | VARCHAR2 | (240) | Source Reference Column | |
SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | Source Reference Column | |
SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | Source Reference Column | |
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | Source Reference Column | ||
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | Source Reference Column | ||
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | Source Reference Column | ||
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | Source Reference Column | ||
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | Source Reference Column | ||
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Source distribution type | |
BFLOW_APPLICATION_ID | NUMBER | (15) | Business flow application identifier | |
BFLOW_ENTITY_CODE | VARCHAR2 | (30) | Business flow entity code | |
BFLOW_SOURCE_ID_NUM_1 | NUMBER | (15) | Business flow source identifier (number) | |
BFLOW_SOURCE_ID_NUM_2 | NUMBER | (15) | Business flow source identifier (number) | |
BFLOW_SOURCE_ID_NUM_3 | NUMBER | (15) | Business flow source identifier (number) | |
BFLOW_SOURCE_ID_NUM_4 | NUMBER | (15) | Business flow source identifier (number) | |
BFLOW_SOURCE_ID_CHAR_1 | VARCHAR2 | (30) | Business flow source identifier (char) | |
BFLOW_SOURCE_ID_CHAR_2 | VARCHAR2 | (30) | Business flow source identifier (char) | |
BFLOW_SOURCE_ID_CHAR_3 | VARCHAR2 | (30) | Business flow source identifier (char) | |
BFLOW_SOURCE_ID_CHAR_4 | VARCHAR2 | (30) | Business flow source identifier (char) | |
BFLOW_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Business flow distribution type | |
BFLOW_DIST_ID_NUM_1 | NUMBER | (15) | Business flow distribution identifier (number) | |
BFLOW_DIST_ID_NUM_2 | NUMBER | (15) | Business flow distribution identifier (number) | |
BFLOW_DIST_ID_NUM_3 | NUMBER | (15) | Business flow distribution identifier (number) | |
BFLOW_DIST_ID_NUM_4 | NUMBER | (15) | Business flow distribution identifier (number) | |
BFLOW_DIST_ID_NUM_5 | NUMBER | (15) | Business flow distribution identifier (number) | |
BFLOW_DIST_ID_CHAR_1 | VARCHAR2 | (30) | Business flow distribution identifier (char) | |
BFLOW_DIST_ID_CHAR_2 | VARCHAR2 | (30) | Business flow distribution identifier (char) | |
BFLOW_DIST_ID_CHAR_3 | VARCHAR2 | (30) | Business flow distribution identifier (char) | |
BFLOW_DIST_ID_CHAR_4 | VARCHAR2 | (30) | Business flow distribution identifier (char) | |
BFLOW_DIST_ID_CHAR_5 | VARCHAR2 | (30) | Business flow distribution identifier (char) | |
PHASE | VARCHAR2 | (30) | Phase | |
CREATION_DATE | DATE | Standard who column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT AE_HEADER_ID
, AE_LINE_NUM
, SOURCE_DISTRIBUTION_ID_CHAR_1
, SOURCE_DISTRIBUTION_ID_CHAR_2
, SOURCE_DISTRIBUTION_ID_CHAR_3
, SOURCE_DISTRIBUTION_ID_CHAR_4
, SOURCE_DISTRIBUTION_ID_CHAR_5
, SOURCE_DISTRIBUTION_ID_NUM_1
, SOURCE_DISTRIBUTION_ID_NUM_2
, SOURCE_DISTRIBUTION_ID_NUM_3
, SOURCE_DISTRIBUTION_ID_NUM_4
, SOURCE_DISTRIBUTION_ID_NUM_5
, SOURCE_DISTRIBUTION_TYPE
, BFLOW_APPLICATION_ID
, BFLOW_ENTITY_CODE
, BFLOW_SOURCE_ID_NUM_1
, BFLOW_SOURCE_ID_NUM_2
, BFLOW_SOURCE_ID_NUM_3
, BFLOW_SOURCE_ID_NUM_4
, BFLOW_SOURCE_ID_CHAR_1
, BFLOW_SOURCE_ID_CHAR_2
, BFLOW_SOURCE_ID_CHAR_3
, BFLOW_SOURCE_ID_CHAR_4
, BFLOW_DISTRIBUTION_TYPE
, BFLOW_DIST_ID_NUM_1
, BFLOW_DIST_ID_NUM_2
, BFLOW_DIST_ID_NUM_3
, BFLOW_DIST_ID_NUM_4
, BFLOW_DIST_ID_NUM_5
, BFLOW_DIST_ID_CHAR_1
, BFLOW_DIST_ID_CHAR_2
, BFLOW_DIST_ID_CHAR_3
, BFLOW_DIST_ID_CHAR_4
, BFLOW_DIST_ID_CHAR_5
, PHASE
, CREATION_DATE
FROM PSA.PSA_XLA_AE_LINES_LOGS;
PSA.PSA_XLA_AE_LINES_LOGS does not reference any database object
PSA.PSA_XLA_AE_LINES_LOGS is referenced by following:
|
|
|