VIEW: APPS.PSA_BC_ALLOC_V

Source

View Text - Preformatted

SELECT d.rowid ROW_ID, d.ledger_id LEDGER_ID, d.event_id EVENT_ID, d.entity_id ENTITY_ID, d.ae_header_id AE_HEADER_ID, d.ae_line_num AE_LINE_NUM, e.entity_code ENTITY_CODE, e.source_id_int_1 SOURCE_ID_INT_1 , e.source_id_int_2 SOURCE_ID_INT_2 , e.source_id_int_3 SOURCE_ID_INT_3 , e.source_id_int_4 SOURCE_ID_INT_4 , e.source_id_char_1 SOURCE_ID_CHAR_1, e.source_id_char_2 SOURCE_ID_CHAR_2, e.source_id_char_3 SOURCE_ID_CHAR_3, e.source_id_char_4 SOURCE_ID_CHAR_4, e.application_id APPLICATION_ID, d.source_distribution_id_num_1 SOURCE_DISTRIBUTION_ID_NUM_1, d.source_distribution_id_num_2 SOURCE_DISTRIBUTION_ID_NUM_2, d.source_distribution_id_num_3 SOURCE_DISTRIBUTION_ID_NUM_3, d.source_distribution_id_num_4 SOURCE_DISTRIBUTION_ID_NUM_4, d.source_distribution_id_num_5 SOURCE_DISTRIBUTION_ID_NUM_5, d.source_distribution_id_char_1 SOURCE_DISTRIBUTION_ID_CHAR_1, d.source_distribution_id_char_2 SOURCE_DISTRIBUTION_ID_CHAR_2, d.source_distribution_id_char_3 SOURCE_DISTRIBUTION_ID_CHAR_3, d.source_distribution_id_char_4 SOURCE_DISTRIBUTION_ID_CHAR_4, d.source_distribution_id_char_5 SOURCE_DISTRIBUTION_ID_CHAR_5, d.source_distribution_type SOURCE_DISTRIBUTION_TYPE, d.alloc_to_entity_code ALLOC_TO_ENTITY_CODE, d.alloc_to_source_id_num_1 ALLOC_TO_SOURCE_ID_NUM_1, d.alloc_to_source_id_num_2 ALLOC_TO_SOURCE_ID_NUM_2, d.alloc_to_source_id_num_3 ALLOC_TO_SOURCE_ID_NUM_3, d.alloc_to_source_id_num_4 ALLOC_TO_SOURCE_ID_NUM_4, d.alloc_to_source_id_char_1 ALLOC_TO_SOURCE_ID_CHAR_1, d.alloc_to_source_id_char_2 ALLOC_TO_SOURCE_ID_CHAR_2, d.alloc_to_source_id_char_3 ALLOC_TO_SOURCE_ID_CHAR_3, d.alloc_to_source_id_char_4 ALLOC_TO_SOURCE_ID_CHAR_4, d.alloc_to_application_id ALLOC_TO_APPLICATION_ID, d.alloc_to_distribution_type ALLOC_TO_DISTRIBUTION_TYPE, d.alloc_to_dist_id_num_1 ALLOC_TO_DIST_ID_NUM_1, d.alloc_to_dist_id_num_2 ALLOC_TO_DIST_ID_NUM_2, d.alloc_to_dist_id_num_3 ALLOC_TO_DIST_ID_NUM_3, d.alloc_to_dist_id_num_4 ALLOC_TO_DIST_ID_NUM_4, d.alloc_to_dist_id_num_5 ALLOC_TO_DIST_ID_NUM_5, d.alloc_to_dist_id_char_1 ALLOC_TO_DIST_ID_CHAR_1, d.alloc_to_dist_id_char_2 ALLOC_TO_DIST_ID_CHAR_2, d.alloc_to_dist_id_char_3 ALLOC_TO_DIST_ID_CHAR_3, d.alloc_to_dist_id_char_4 ALLOC_TO_DIST_ID_CHAR_4, d.alloc_to_dist_id_char_5 ALLOC_TO_DIST_ID_CHAR_5 FROM xla_events_gt e, xla_ae_lines_gt d WHERE e.event_id = d.event_id

View Text - HTML Formatted

SELECT D.ROWID ROW_ID
, D.LEDGER_ID LEDGER_ID
, D.EVENT_ID EVENT_ID
, D.ENTITY_ID ENTITY_ID
, D.AE_HEADER_ID AE_HEADER_ID
, D.AE_LINE_NUM AE_LINE_NUM
, E.ENTITY_CODE ENTITY_CODE
, E.SOURCE_ID_INT_1 SOURCE_ID_INT_1
, E.SOURCE_ID_INT_2 SOURCE_ID_INT_2
, E.SOURCE_ID_INT_3 SOURCE_ID_INT_3
, E.SOURCE_ID_INT_4 SOURCE_ID_INT_4
, E.SOURCE_ID_CHAR_1 SOURCE_ID_CHAR_1
, E.SOURCE_ID_CHAR_2 SOURCE_ID_CHAR_2
, E.SOURCE_ID_CHAR_3 SOURCE_ID_CHAR_3
, E.SOURCE_ID_CHAR_4 SOURCE_ID_CHAR_4
, E.APPLICATION_ID APPLICATION_ID
, D.SOURCE_DISTRIBUTION_ID_NUM_1 SOURCE_DISTRIBUTION_ID_NUM_1
, D.SOURCE_DISTRIBUTION_ID_NUM_2 SOURCE_DISTRIBUTION_ID_NUM_2
, D.SOURCE_DISTRIBUTION_ID_NUM_3 SOURCE_DISTRIBUTION_ID_NUM_3
, D.SOURCE_DISTRIBUTION_ID_NUM_4 SOURCE_DISTRIBUTION_ID_NUM_4
, D.SOURCE_DISTRIBUTION_ID_NUM_5 SOURCE_DISTRIBUTION_ID_NUM_5
, D.SOURCE_DISTRIBUTION_ID_CHAR_1 SOURCE_DISTRIBUTION_ID_CHAR_1
, D.SOURCE_DISTRIBUTION_ID_CHAR_2 SOURCE_DISTRIBUTION_ID_CHAR_2
, D.SOURCE_DISTRIBUTION_ID_CHAR_3 SOURCE_DISTRIBUTION_ID_CHAR_3
, D.SOURCE_DISTRIBUTION_ID_CHAR_4 SOURCE_DISTRIBUTION_ID_CHAR_4
, D.SOURCE_DISTRIBUTION_ID_CHAR_5 SOURCE_DISTRIBUTION_ID_CHAR_5
, D.SOURCE_DISTRIBUTION_TYPE SOURCE_DISTRIBUTION_TYPE
, D.ALLOC_TO_ENTITY_CODE ALLOC_TO_ENTITY_CODE
, D.ALLOC_TO_SOURCE_ID_NUM_1 ALLOC_TO_SOURCE_ID_NUM_1
, D.ALLOC_TO_SOURCE_ID_NUM_2 ALLOC_TO_SOURCE_ID_NUM_2
, D.ALLOC_TO_SOURCE_ID_NUM_3 ALLOC_TO_SOURCE_ID_NUM_3
, D.ALLOC_TO_SOURCE_ID_NUM_4 ALLOC_TO_SOURCE_ID_NUM_4
, D.ALLOC_TO_SOURCE_ID_CHAR_1 ALLOC_TO_SOURCE_ID_CHAR_1
, D.ALLOC_TO_SOURCE_ID_CHAR_2 ALLOC_TO_SOURCE_ID_CHAR_2
, D.ALLOC_TO_SOURCE_ID_CHAR_3 ALLOC_TO_SOURCE_ID_CHAR_3
, D.ALLOC_TO_SOURCE_ID_CHAR_4 ALLOC_TO_SOURCE_ID_CHAR_4
, D.ALLOC_TO_APPLICATION_ID ALLOC_TO_APPLICATION_ID
, D.ALLOC_TO_DISTRIBUTION_TYPE ALLOC_TO_DISTRIBUTION_TYPE
, D.ALLOC_TO_DIST_ID_NUM_1 ALLOC_TO_DIST_ID_NUM_1
, D.ALLOC_TO_DIST_ID_NUM_2 ALLOC_TO_DIST_ID_NUM_2
, D.ALLOC_TO_DIST_ID_NUM_3 ALLOC_TO_DIST_ID_NUM_3
, D.ALLOC_TO_DIST_ID_NUM_4 ALLOC_TO_DIST_ID_NUM_4
, D.ALLOC_TO_DIST_ID_NUM_5 ALLOC_TO_DIST_ID_NUM_5
, D.ALLOC_TO_DIST_ID_CHAR_1 ALLOC_TO_DIST_ID_CHAR_1
, D.ALLOC_TO_DIST_ID_CHAR_2 ALLOC_TO_DIST_ID_CHAR_2
, D.ALLOC_TO_DIST_ID_CHAR_3 ALLOC_TO_DIST_ID_CHAR_3
, D.ALLOC_TO_DIST_ID_CHAR_4 ALLOC_TO_DIST_ID_CHAR_4
, D.ALLOC_TO_DIST_ID_CHAR_5 ALLOC_TO_DIST_ID_CHAR_5
FROM XLA_EVENTS_GT E
, XLA_AE_LINES_GT D
WHERE E.EVENT_ID = D.EVENT_ID