XCC_UNDO_REDO_ERRORS_V
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: VIEW
Columns
Name |
---|
CONTROL_BUDGET_NAME PERIOD_NAME VALIDATION_ERROR BUDGET_ACCOUNT ENTERED_AMOUNT BUDGET_CURRENCY ENTERED_CURRENCY CONVERSION_DATE USER_CONVERSION_TYPE SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 |
Query
SQL_Statement |
---|
SELECT cb.name control_budget_name, act.period_name, val.meaning validation_error, acct.segment_value1 || decode(acct.segment_value2, NULL, NULL, '-'||acct.segment_value2) || decode(acct.segment_value3, NULL, NULL, '-'||acct.segment_value3) || decode(acct.segment_value4, NULL, NULL, '-'||acct.segment_value4) || decode(acct.segment_value5, NULL, NULL, '-'||acct.segment_value5) || decode(acct.segment_value6, NULL, NULL, '-'||acct.segment_value6) || decode(acct.segment_value7, NULL, NULL, '-'||acct.segment_value7) || decode(acct.segment_value8, NULL, NULL, '-'||acct.segment_value8) || decode(acct.segment_value9, NULL, NULL, '-'||acct.segment_value9) || decode(acct.segment_value10, NULL, NULL, '-'||acct.segment_value10) || decode(acct.segment_value11, NULL, NULL, '-'||acct.segment_value11) || decode(acct.segment_value12, NULL, NULL, '-'||acct.segment_value12) || decode(acct.segment_value13, NULL, NULL, '-'||acct.segment_value13) || decode(acct.segment_value14, NULL, NULL, '-'||acct.segment_value14) || decode(acct.segment_value15, NULL, NULL, '-'||acct.segment_value15) || decode(acct.segment_value16, NULL, NULL, '-'||acct.segment_value16) || decode(acct.segment_value17, NULL, NULL, '-'||acct.segment_value17) || decode(acct.segment_value18, NULL, NULL, '-'||acct.segment_value18) || decode(acct.segment_value19, NULL, NULL, '-'||acct.segment_value19) || decode(acct.segment_value20, NULL, NULL, '-'||acct.segment_value20) || decode(acct.segment_value21, NULL, NULL, '-'||acct.segment_value21) || decode(acct.segment_value22, NULL, NULL, '-'||acct.segment_value22) || decode(acct.segment_value23, NULL, NULL, '-'||acct.segment_value23) || decode(acct.segment_value24, NULL, NULL, '-'||acct.segment_value24) || decode(acct.segment_value25, NULL, NULL, '-'||acct.segment_value25) || decode(acct.segment_value26, NULL, NULL, '-'||acct.segment_value26) || decode(acct.segment_value27, NULL, NULL, '-'||acct.segment_value27) || decode(acct.segment_value28, NULL, NULL, '-'||acct.segment_value28) || decode(acct.segment_value29, NULL, NULL, '-'||acct.segment_value29) || decode(acct.segment_value30, NULL, NULL, '-'||acct.segment_value30) budget_account, act.entered_amount, cb.currency_code budget_currency, act.entered_currency, ln.conversion_date, conv.user_conversion_type, ln.source_line_id_1, ln.source_line_id_2, ln.source_line_id_3, ln.source_line_id_4, ln.source_line_id_5, ln.source_line_id_6 FROM xcc_undo_redo_data_sets_gt ds, xcc_balance_activities act, xcc_tr_lines ln, xcc_control_budgets cb, fnd_lookup_values val, xcc_budget_accounts acct, gl_daily_conversion_types conv WHERE ln.data_set_id = ds.data_set_id AND ln.result_code = 'FAILED' AND act.header_num = ln.header_num AND act.line_num = ln.line_num AND act.result_code like 'F%' AND cb.control_budget_id = act.control_budget_id AND val.view_application_id = 0 AND val.lookup_type = 'XCC_BC_ACTIVITY_STATUSES' AND val.lookup_code = act.result_code AND val.language = userenv('LANG') AND acct.budget_code_combination_id(+) = act.budget_ccid AND conv.conversion_type = act.conversion_type_code |