VIEW: APPS.IGS_OR_UNIT_ACCTS_V

Source

View Text - Preformatted

SELECT orua.row_id, orua.org_account_id, orua.org_unit_cd, orua.start_dt, accseg.segment, accseg.segment_name, accseg.segment_num, orua.segment_value, DECODE(orua.segment_value,NULL,NULL,igs_fi_gen_007.get_segval_desc(accseg.flex_value_set_id,orua.segment_value)), accseg.flex_value_set_id, accseg.validation_type, accseg.independent_segment_num, accseg.display_flag, orua.org_id, orua.created_by, orua.creation_date, orua.last_updated_by, orua.last_update_date, orua.last_update_login FROM igs_or_unit_accts orua, igs_fi_acct_segs_v accseg WHERE accseg.segment = orua.segment(+) AND accseg.segment_num = orua.segment_num(+) ORDER BY accseg.segment_num

View Text - HTML Formatted

SELECT ORUA.ROW_ID
, ORUA.ORG_ACCOUNT_ID
, ORUA.ORG_UNIT_CD
, ORUA.START_DT
, ACCSEG.SEGMENT
, ACCSEG.SEGMENT_NAME
, ACCSEG.SEGMENT_NUM
, ORUA.SEGMENT_VALUE
, DECODE(ORUA.SEGMENT_VALUE
, NULL
, NULL
, IGS_FI_GEN_007.GET_SEGVAL_DESC(ACCSEG.FLEX_VALUE_SET_ID
, ORUA.SEGMENT_VALUE))
, ACCSEG.FLEX_VALUE_SET_ID
, ACCSEG.VALIDATION_TYPE
, ACCSEG.INDEPENDENT_SEGMENT_NUM
, ACCSEG.DISPLAY_FLAG
, ORUA.ORG_ID
, ORUA.CREATED_BY
, ORUA.CREATION_DATE
, ORUA.LAST_UPDATED_BY
, ORUA.LAST_UPDATE_DATE
, ORUA.LAST_UPDATE_LOGIN
FROM IGS_OR_UNIT_ACCTS ORUA
, IGS_FI_ACCT_SEGS_V ACCSEG
WHERE ACCSEG.SEGMENT = ORUA.SEGMENT(+)
AND ACCSEG.SEGMENT_NUM = ORUA.SEGMENT_NUM(+) ORDER BY ACCSEG.SEGMENT_NUM