eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PSA.PSA_XLA_AE_LINES_LOGS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	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.

Query Text

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;

Dependencies

[top of page]

PSA.PSA_XLA_AE_LINES_LOGS does not reference any database object

PSA.PSA_XLA_AE_LINES_LOGS is referenced by following:

APPS: PSA_XLA_AE_LINES_LOGS