VIEW: APPS.XLA_PAD_INQ_LINES_AF_SD_FVL

Source

View Text - Preformatted

SELECT row_id ,application_id ,amb_context_code ,product_rule_code ,product_rule_name ,product_rule_type_code ,product_rule_type_code_dsp ,line_definition_owner_code ,line_definition_owner ,line_definition_code ,line_definition_name ,locking_status_flag ,event_class_code ,event_class_name ,event_type_code ,event_type_name ,accounting_line_code ,accounting_line_name ,accounting_line_type_code ,accounting_line_type_code_dsp ,accounting_entry_type_code ,accounting_entry_type_dsp ,accounting_class_code ,accounting_class_name ,accounting_line_side_code ,accounting_line_side_dsp ,switch_side_flag ,switch_side_flag_dsp ,merge_duplicate_code ,merge_duplicate_dsp ,description_code ,description_name ,description_type_code ,description_type_code_dsp ,analytical_criterion_code ,analytical_criterion_type_code ,segment_rule_code ,segment_rule_name ,segment_rule_type_code ,segment_rule_type_code_dsp ,flexfield_assign_mode ,accounting_coa_id ,accounting_coa_name ,flexfield_segment_code ,flexfield_segment_name ,creation_date ,created_by ,last_update_date ,last_update_login ,last_updated_by FROM XLA_PAD_INQ_LINES_AF_FVL UNION SELECT row_id ,application_id ,amb_context_code ,product_rule_code ,product_rule_name ,product_rule_type_code ,product_rule_type_code_dsp ,line_definition_owner_code ,line_definition_owner ,line_definition_code ,line_definition_name ,locking_status_flag ,event_class_code ,event_class_name ,event_type_code ,event_type_name ,accounting_line_code ,accounting_line_name ,accounting_line_type_code ,accounting_line_type_code_dsp ,accounting_entry_type_code ,accounting_entry_type_dsp ,accounting_class_code ,accounting_class_name ,accounting_line_side_code ,accounting_line_side_dsp ,switch_side_flag ,switch_side_flag_dsp ,merge_duplicate_code ,merge_duplicate_dsp ,description_code ,description_name ,description_type_code ,description_type_code_dsp ,analytical_criterion_code ,analytical_criterion_type_code ,segment_rule_code ,segment_rule_name ,segment_rule_type_code ,segment_rule_type_code_dsp ,flexfield_assign_mode ,accounting_coa_id ,accounting_coa_name ,flexfield_segment_code ,flexfield_segment_name ,creation_date ,created_by ,last_update_date ,last_update_login ,last_updated_by FROM XLA_PAD_INQ_LINES_SD_FVL

View Text - HTML Formatted

SELECT ROW_ID
, APPLICATION_ID
, AMB_CONTEXT_CODE
, PRODUCT_RULE_CODE
, PRODUCT_RULE_NAME
, PRODUCT_RULE_TYPE_CODE
, PRODUCT_RULE_TYPE_CODE_DSP
, LINE_DEFINITION_OWNER_CODE
, LINE_DEFINITION_OWNER
, LINE_DEFINITION_CODE
, LINE_DEFINITION_NAME
, LOCKING_STATUS_FLAG
, EVENT_CLASS_CODE
, EVENT_CLASS_NAME
, EVENT_TYPE_CODE
, EVENT_TYPE_NAME
, ACCOUNTING_LINE_CODE
, ACCOUNTING_LINE_NAME
, ACCOUNTING_LINE_TYPE_CODE
, ACCOUNTING_LINE_TYPE_CODE_DSP
, ACCOUNTING_ENTRY_TYPE_CODE
, ACCOUNTING_ENTRY_TYPE_DSP
, ACCOUNTING_CLASS_CODE
, ACCOUNTING_CLASS_NAME
, ACCOUNTING_LINE_SIDE_CODE
, ACCOUNTING_LINE_SIDE_DSP
, SWITCH_SIDE_FLAG
, SWITCH_SIDE_FLAG_DSP
, MERGE_DUPLICATE_CODE
, MERGE_DUPLICATE_DSP
, DESCRIPTION_CODE
, DESCRIPTION_NAME
, DESCRIPTION_TYPE_CODE
, DESCRIPTION_TYPE_CODE_DSP
, ANALYTICAL_CRITERION_CODE
, ANALYTICAL_CRITERION_TYPE_CODE
, SEGMENT_RULE_CODE
, SEGMENT_RULE_NAME
, SEGMENT_RULE_TYPE_CODE
, SEGMENT_RULE_TYPE_CODE_DSP
, FLEXFIELD_ASSIGN_MODE
, ACCOUNTING_COA_ID
, ACCOUNTING_COA_NAME
, FLEXFIELD_SEGMENT_CODE
, FLEXFIELD_SEGMENT_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM XLA_PAD_INQ_LINES_AF_FVL UNION SELECT ROW_ID
, APPLICATION_ID
, AMB_CONTEXT_CODE
, PRODUCT_RULE_CODE
, PRODUCT_RULE_NAME
, PRODUCT_RULE_TYPE_CODE
, PRODUCT_RULE_TYPE_CODE_DSP
, LINE_DEFINITION_OWNER_CODE
, LINE_DEFINITION_OWNER
, LINE_DEFINITION_CODE
, LINE_DEFINITION_NAME
, LOCKING_STATUS_FLAG
, EVENT_CLASS_CODE
, EVENT_CLASS_NAME
, EVENT_TYPE_CODE
, EVENT_TYPE_NAME
, ACCOUNTING_LINE_CODE
, ACCOUNTING_LINE_NAME
, ACCOUNTING_LINE_TYPE_CODE
, ACCOUNTING_LINE_TYPE_CODE_DSP
, ACCOUNTING_ENTRY_TYPE_CODE
, ACCOUNTING_ENTRY_TYPE_DSP
, ACCOUNTING_CLASS_CODE
, ACCOUNTING_CLASS_NAME
, ACCOUNTING_LINE_SIDE_CODE
, ACCOUNTING_LINE_SIDE_DSP
, SWITCH_SIDE_FLAG
, SWITCH_SIDE_FLAG_DSP
, MERGE_DUPLICATE_CODE
, MERGE_DUPLICATE_DSP
, DESCRIPTION_CODE
, DESCRIPTION_NAME
, DESCRIPTION_TYPE_CODE
, DESCRIPTION_TYPE_CODE_DSP
, ANALYTICAL_CRITERION_CODE
, ANALYTICAL_CRITERION_TYPE_CODE
, SEGMENT_RULE_CODE
, SEGMENT_RULE_NAME
, SEGMENT_RULE_TYPE_CODE
, SEGMENT_RULE_TYPE_CODE_DSP
, FLEXFIELD_ASSIGN_MODE
, ACCOUNTING_COA_ID
, ACCOUNTING_COA_NAME
, FLEXFIELD_SEGMENT_CODE
, FLEXFIELD_SEGMENT_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM XLA_PAD_INQ_LINES_SD_FVL