VIEW: APPS.IGS_PS_UNIT_ACCTS_V

Source

View Text - Preformatted

SELECT psua.row_id, psua.unit_account_id, psua.unit_cd, psua.version_number, accseg.segment, accseg.segment_name, accseg.segment_num, psua.segment_value, DECODE(psua.segment_value,NULL,NULL,igs_fi_gen_007.get_segval_desc(accseg.flex_value_set_id,psua.segment_value)), accseg.flex_value_set_id, accseg.validation_type, accseg.independent_segment_num, accseg.display_flag, psua.org_id, psua.created_by, psua.creation_date, psua.last_updated_by, psua.last_update_date, psua.last_update_login FROM igs_ps_unit_accts psua, igs_fi_acct_segs_v accseg WHERE accseg.segment = psua.segment(+) AND accseg.segment_num = psua.segment_num(+) ORDER BY accseg.segment_num

View Text - HTML Formatted

SELECT PSUA.ROW_ID
, PSUA.UNIT_ACCOUNT_ID
, PSUA.UNIT_CD
, PSUA.VERSION_NUMBER
, ACCSEG.SEGMENT
, ACCSEG.SEGMENT_NAME
, ACCSEG.SEGMENT_NUM
, PSUA.SEGMENT_VALUE
, DECODE(PSUA.SEGMENT_VALUE
, NULL
, NULL
, IGS_FI_GEN_007.GET_SEGVAL_DESC(ACCSEG.FLEX_VALUE_SET_ID
, PSUA.SEGMENT_VALUE))
, ACCSEG.FLEX_VALUE_SET_ID
, ACCSEG.VALIDATION_TYPE
, ACCSEG.INDEPENDENT_SEGMENT_NUM
, ACCSEG.DISPLAY_FLAG
, PSUA.ORG_ID
, PSUA.CREATED_BY
, PSUA.CREATION_DATE
, PSUA.LAST_UPDATED_BY
, PSUA.LAST_UPDATE_DATE
, PSUA.LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_ACCTS PSUA
, IGS_FI_ACCT_SEGS_V ACCSEG
WHERE ACCSEG.SEGMENT = PSUA.SEGMENT(+)
AND ACCSEG.SEGMENT_NUM = PSUA.SEGMENT_NUM(+) ORDER BY ACCSEG.SEGMENT_NUM