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.

[Home] [Help]

VIEW: PSA.PSA_XLA_AE_LINES_LOGS#

Source

View Text - Preformatted


select AE_HEADER_ID AE_HEADER_ID, AE_LINE_NUM AE_LINE_NUM, SOURCE_DISTRIBUTION_ID_CHAR_1 SOURCE_DISTRIBUTION_ID_CHAR_1, SOURCE_DISTRIBUTION_ID_CHAR_2 SOURCE_DISTRIBUTION_ID_CHAR_2, SOURCE_DISTRIBUTION_ID_CHAR_3 SOURCE_DISTRIBUTION_ID_CHAR_3, SOURCE_DISTRIBUTION_ID_CHAR_4 SOURCE_DISTRIBUTION_ID_CHAR_4, SOURCE_DISTRIBUTION_ID_CHAR_5 SOURCE_DISTRIBUTION_ID_CHAR_5, SOURCE_DISTRIBUTION_ID_NUM_1 SOURCE_DISTRIBUTION_ID_NUM_1, SOURCE_DISTRIBUTION_ID_NUM_2 SOURCE_DISTRIBUTION_ID_NUM_2, SOURCE_DISTRIBUTION_ID_NUM_3 SOURCE_DISTRIBUTION_ID_NUM_3, SOURCE_DISTRIBUTION_ID_NUM_4 SOURCE_DISTRIBUTION_ID_NUM_4, SOURCE_DISTRIBUTION_ID_NUM_5 SOURCE_DISTRIBUTION_ID_NUM_5, SOURCE_DISTRIBUTION_TYPE SOURCE_DISTRIBUTION_TYPE, BFLOW_APPLICATION_ID BFLOW_APPLICATION_ID, BFLOW_ENTITY_CODE BFLOW_ENTITY_CODE, BFLOW_SOURCE_ID_NUM_1 BFLOW_SOURCE_ID_NUM_1, BFLOW_SOURCE_ID_NUM_2 BFLOW_SOURCE_ID_NUM_2, BFLOW_SOURCE_ID_NUM_3 BFLOW_SOURCE_ID_NUM_3, BFLOW_SOURCE_ID_NUM_4 BFLOW_SOURCE_ID_NUM_4, BFLOW_SOURCE_ID_CHAR_1 BFLOW_SOURCE_ID_CHAR_1, BFLOW_SOURCE_ID_CHAR_2 BFLOW_SOURCE_ID_CHAR_2, BFLOW_SOURCE_ID_CHAR_3 BFLOW_SOURCE_ID_CHAR_3, BFLOW_SOURCE_ID_CHAR_4 BFLOW_SOURCE_ID_CHAR_4, BFLOW_DISTRIBUTION_TYPE BFLOW_DISTRIBUTION_TYPE, BFLOW_DIST_ID_NUM_1 BFLOW_DIST_ID_NUM_1, BFLOW_DIST_ID_NUM_2 BFLOW_DIST_ID_NUM_2, BFLOW_DIST_ID_NUM_3 BFLOW_DIST_ID_NUM_3, BFLOW_DIST_ID_NUM_4 BFLOW_DIST_ID_NUM_4, BFLOW_DIST_ID_NUM_5 BFLOW_DIST_ID_NUM_5, BFLOW_DIST_ID_CHAR_1 BFLOW_DIST_ID_CHAR_1, BFLOW_DIST_ID_CHAR_2 BFLOW_DIST_ID_CHAR_2, BFLOW_DIST_ID_CHAR_3 BFLOW_DIST_ID_CHAR_3, BFLOW_DIST_ID_CHAR_4 BFLOW_DIST_ID_CHAR_4, BFLOW_DIST_ID_CHAR_5 BFLOW_DIST_ID_CHAR_5, PHASE PHASE, CREATION_DATE CREATION_DATE from "PSA"."PSA_XLA_AE_LINES_LOGS"

View Text - HTML Formatted

SELECT AE_HEADER_ID AE_HEADER_ID
, AE_LINE_NUM AE_LINE_NUM
, SOURCE_DISTRIBUTION_ID_CHAR_1 SOURCE_DISTRIBUTION_ID_CHAR_1
, SOURCE_DISTRIBUTION_ID_CHAR_2 SOURCE_DISTRIBUTION_ID_CHAR_2
, SOURCE_DISTRIBUTION_ID_CHAR_3 SOURCE_DISTRIBUTION_ID_CHAR_3
, SOURCE_DISTRIBUTION_ID_CHAR_4 SOURCE_DISTRIBUTION_ID_CHAR_4
, SOURCE_DISTRIBUTION_ID_CHAR_5 SOURCE_DISTRIBUTION_ID_CHAR_5
, SOURCE_DISTRIBUTION_ID_NUM_1 SOURCE_DISTRIBUTION_ID_NUM_1
, SOURCE_DISTRIBUTION_ID_NUM_2 SOURCE_DISTRIBUTION_ID_NUM_2
, SOURCE_DISTRIBUTION_ID_NUM_3 SOURCE_DISTRIBUTION_ID_NUM_3
, SOURCE_DISTRIBUTION_ID_NUM_4 SOURCE_DISTRIBUTION_ID_NUM_4
, SOURCE_DISTRIBUTION_ID_NUM_5 SOURCE_DISTRIBUTION_ID_NUM_5
, SOURCE_DISTRIBUTION_TYPE SOURCE_DISTRIBUTION_TYPE
, BFLOW_APPLICATION_ID BFLOW_APPLICATION_ID
, BFLOW_ENTITY_CODE BFLOW_ENTITY_CODE
, BFLOW_SOURCE_ID_NUM_1 BFLOW_SOURCE_ID_NUM_1
, BFLOW_SOURCE_ID_NUM_2 BFLOW_SOURCE_ID_NUM_2
, BFLOW_SOURCE_ID_NUM_3 BFLOW_SOURCE_ID_NUM_3
, BFLOW_SOURCE_ID_NUM_4 BFLOW_SOURCE_ID_NUM_4
, BFLOW_SOURCE_ID_CHAR_1 BFLOW_SOURCE_ID_CHAR_1
, BFLOW_SOURCE_ID_CHAR_2 BFLOW_SOURCE_ID_CHAR_2
, BFLOW_SOURCE_ID_CHAR_3 BFLOW_SOURCE_ID_CHAR_3
, BFLOW_SOURCE_ID_CHAR_4 BFLOW_SOURCE_ID_CHAR_4
, BFLOW_DISTRIBUTION_TYPE BFLOW_DISTRIBUTION_TYPE
, BFLOW_DIST_ID_NUM_1 BFLOW_DIST_ID_NUM_1
, BFLOW_DIST_ID_NUM_2 BFLOW_DIST_ID_NUM_2
, BFLOW_DIST_ID_NUM_3 BFLOW_DIST_ID_NUM_3
, BFLOW_DIST_ID_NUM_4 BFLOW_DIST_ID_NUM_4
, BFLOW_DIST_ID_NUM_5 BFLOW_DIST_ID_NUM_5
, BFLOW_DIST_ID_CHAR_1 BFLOW_DIST_ID_CHAR_1
, BFLOW_DIST_ID_CHAR_2 BFLOW_DIST_ID_CHAR_2
, BFLOW_DIST_ID_CHAR_3 BFLOW_DIST_ID_CHAR_3
, BFLOW_DIST_ID_CHAR_4 BFLOW_DIST_ID_CHAR_4
, BFLOW_DIST_ID_CHAR_5 BFLOW_DIST_ID_CHAR_5
, PHASE PHASE
, CREATION_DATE CREATION_DATE
FROM "PSA"."PSA_XLA_AE_LINES_LOGS"