VIEW: APPS.XLA_PSA_BC_LINES_V

Source

View Text - Preformatted

SELECT l.ledger_id , l.event_id , l.entity_id , l.ae_header_id , l.ae_line_num , l.balance_type_code , l.accounting_date , l.period_name , l.je_category_name , l.budget_version_id , l.encumbrance_type_id , l.code_combination_id , l.entered_currency_code , l.entered_dr , l.entered_cr , l.accounted_dr , l.accounted_cr , d.bflow_application_id apply_to_application_id , d.bflow_entity_code apply_to_entity_code , d.bflow_source_id_num_1 apply_to_source_id_int_1 , d.bflow_source_id_num_2 apply_to_source_id_int_2 , d.bflow_source_id_num_3 apply_to_source_id_int_3 , d.bflow_source_id_num_4 apply_to_source_id_int_4 , d.bflow_source_id_char_1 apply_to_source_id_char_1 , d.bflow_source_id_char_2 apply_to_source_id_char_2 , d.bflow_source_id_char_3 apply_to_source_id_char_3 , d.bflow_source_id_char_4 apply_to_source_id_char_4 , d.bflow_distribution_type apply_to_dist_type , d.bflow_dist_id_num_1 apply_to_dist_id_num_1 , d.bflow_dist_id_num_2 apply_to_dist_id_num_2 , d.bflow_dist_id_num_3 apply_to_dist_id_num_3 , d.bflow_dist_id_num_4 apply_to_dist_id_num_4 , d.bflow_dist_id_num_5 apply_to_dist_id_num_5 , d.bflow_dist_id_char_1 apply_to_dist_id_char_1 , d.bflow_dist_id_char_2 apply_to_dist_id_char_2 , d.bflow_dist_id_char_3 apply_to_dist_id_char_3 , d.bflow_dist_id_char_4 apply_to_dist_id_char_4 , d.bflow_dist_id_char_5 apply_to_dist_id_char_5 , d.source_distribution_type , d.source_distribution_id_char_1 , d.source_distribution_id_char_2 , d.source_distribution_id_char_3 , d.source_distribution_id_char_4 , d.source_distribution_id_char_5 , d.source_distribution_id_num_1 , d.source_distribution_id_num_2 , d.source_distribution_id_num_3 , d.source_distribution_id_num_4 , d.source_distribution_id_num_5 FROM xla_validation_lines_gt l , xla_ae_lines_gt d WHERE d.ae_header_id = l.ae_header_id AND d.ae_line_num = l.ae_line_num AND l.accounting_entry_status_code = 0 AND l.balancing_line_type IN ('P', 'C')

View Text - HTML Formatted

SELECT L.LEDGER_ID
, L.EVENT_ID
, L.ENTITY_ID
, L.AE_HEADER_ID
, L.AE_LINE_NUM
, L.BALANCE_TYPE_CODE
, L.ACCOUNTING_DATE
, L.PERIOD_NAME
, L.JE_CATEGORY_NAME
, L.BUDGET_VERSION_ID
, L.ENCUMBRANCE_TYPE_ID
, L.CODE_COMBINATION_ID
, L.ENTERED_CURRENCY_CODE
, L.ENTERED_DR
, L.ENTERED_CR
, L.ACCOUNTED_DR
, L.ACCOUNTED_CR
, D.BFLOW_APPLICATION_ID APPLY_TO_APPLICATION_ID
, D.BFLOW_ENTITY_CODE APPLY_TO_ENTITY_CODE
, D.BFLOW_SOURCE_ID_NUM_1 APPLY_TO_SOURCE_ID_INT_1
, D.BFLOW_SOURCE_ID_NUM_2 APPLY_TO_SOURCE_ID_INT_2
, D.BFLOW_SOURCE_ID_NUM_3 APPLY_TO_SOURCE_ID_INT_3
, D.BFLOW_SOURCE_ID_NUM_4 APPLY_TO_SOURCE_ID_INT_4
, D.BFLOW_SOURCE_ID_CHAR_1 APPLY_TO_SOURCE_ID_CHAR_1
, D.BFLOW_SOURCE_ID_CHAR_2 APPLY_TO_SOURCE_ID_CHAR_2
, D.BFLOW_SOURCE_ID_CHAR_3 APPLY_TO_SOURCE_ID_CHAR_3
, D.BFLOW_SOURCE_ID_CHAR_4 APPLY_TO_SOURCE_ID_CHAR_4
, D.BFLOW_DISTRIBUTION_TYPE APPLY_TO_DIST_TYPE
, D.BFLOW_DIST_ID_NUM_1 APPLY_TO_DIST_ID_NUM_1
, D.BFLOW_DIST_ID_NUM_2 APPLY_TO_DIST_ID_NUM_2
, D.BFLOW_DIST_ID_NUM_3 APPLY_TO_DIST_ID_NUM_3
, D.BFLOW_DIST_ID_NUM_4 APPLY_TO_DIST_ID_NUM_4
, D.BFLOW_DIST_ID_NUM_5 APPLY_TO_DIST_ID_NUM_5
, D.BFLOW_DIST_ID_CHAR_1 APPLY_TO_DIST_ID_CHAR_1
, D.BFLOW_DIST_ID_CHAR_2 APPLY_TO_DIST_ID_CHAR_2
, D.BFLOW_DIST_ID_CHAR_3 APPLY_TO_DIST_ID_CHAR_3
, D.BFLOW_DIST_ID_CHAR_4 APPLY_TO_DIST_ID_CHAR_4
, D.BFLOW_DIST_ID_CHAR_5 APPLY_TO_DIST_ID_CHAR_5
, D.SOURCE_DISTRIBUTION_TYPE
, D.SOURCE_DISTRIBUTION_ID_CHAR_1
, D.SOURCE_DISTRIBUTION_ID_CHAR_2
, D.SOURCE_DISTRIBUTION_ID_CHAR_3
, D.SOURCE_DISTRIBUTION_ID_CHAR_4
, D.SOURCE_DISTRIBUTION_ID_CHAR_5
, D.SOURCE_DISTRIBUTION_ID_NUM_1
, D.SOURCE_DISTRIBUTION_ID_NUM_2
, D.SOURCE_DISTRIBUTION_ID_NUM_3
, D.SOURCE_DISTRIBUTION_ID_NUM_4
, D.SOURCE_DISTRIBUTION_ID_NUM_5
FROM XLA_VALIDATION_LINES_GT L
, XLA_AE_LINES_GT D
WHERE D.AE_HEADER_ID = L.AE_HEADER_ID
AND D.AE_LINE_NUM = L.AE_LINE_NUM
AND L.ACCOUNTING_ENTRY_STATUS_CODE = 0
AND L.BALANCING_LINE_TYPE IN ('P'
, 'C')