CST_XLA_USER_ADJUSTMENTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
USER_ADJUSTMENT_ID POSTED_FLAG ADJUSTMENT_DATE USER_ADJ_DATE_FLAG USER_ADJUSTMENT_FLAG PAC_CODE_COMBINATION_ID REASON_CODE ADJUSTMENT_TYPE

Query

SQL_Statement

SELECT user_adjustment_id user_adjustment_id, posted_flag posted_flag, CAST(adjustment_date AS DATE) adjustment_date, user_adj_date_flag user_adj_date_flag, user_defined_flag user_adjustment_flag, CAST(NULL AS NUMBER) pac_code_combination_id, reason_code reason_code, CAST('NON-PAC' AS VARCHAR(18)) adjustment_type FROM cst_user_adjustments UNION ALL SELECT pac_user_adjustment_id user_adjustment_id, CAST(decode(processed_flag, 'Y', 'Y', 'N') AS VARCHAR2(1)) posted_flag, CAST(adjustment_date AS DATE) adjustment_date, CAST(NULL AS VARCHAR2(5)) user_adj_date_flag, CAST('Y' AS VARCHAR2(5)) user_adjustment_flag, code_combination_id pac_code_combination_id, adjustment_reason_code reason_code, CAST('PAC-ADJ' AS VARCHAR(18)) adjustment_type FROM cst_pac_user_adj_headers