VIEW: APPS.IGS_PR_INST_STA_REF_V

Source

View Text - Preformatted

SELECT isr.ROWID, isr.STAT_TYPE, isr.UNIT_REF_CD, rc.DESCRIPTION, isr.INCLUDE_OR_EXCLUDE, isr.reference_cd_type, isr.CREATED_BY, isr.CREATION_DATE, isr.LAST_UPDATED_BY, isr.LAST_UPDATE_DATE, isr.LAST_UPDATE_LOGIN FROM igs_pr_inst_sta_ref isr, igs_ge_ref_cd_type rct, igs_ge_ref_cd rc WHERE isr.unit_ref_cd = rc.reference_cd AND isr.reference_cd_type = rc.reference_cd_type AND rc.reference_cd_type = rct.reference_cd_type AND nvl(rct.closed_ind,'N') = 'N' AND ( rct.unit_flag = 'Y' OR rct.unit_section_flag = 'Y' OR rct.unit_section_occurrence_flag = 'Y' ) AND rct.s_reference_cd_type = 'STATS'

View Text - HTML Formatted

SELECT ISR.ROWID
, ISR.STAT_TYPE
, ISR.UNIT_REF_CD
, RC.DESCRIPTION
, ISR.INCLUDE_OR_EXCLUDE
, ISR.REFERENCE_CD_TYPE
, ISR.CREATED_BY
, ISR.CREATION_DATE
, ISR.LAST_UPDATED_BY
, ISR.LAST_UPDATE_DATE
, ISR.LAST_UPDATE_LOGIN
FROM IGS_PR_INST_STA_REF ISR
, IGS_GE_REF_CD_TYPE RCT
, IGS_GE_REF_CD RC
WHERE ISR.UNIT_REF_CD = RC.REFERENCE_CD
AND ISR.REFERENCE_CD_TYPE = RC.REFERENCE_CD_TYPE
AND RC.REFERENCE_CD_TYPE = RCT.REFERENCE_CD_TYPE
AND NVL(RCT.CLOSED_IND
, 'N') = 'N'
AND ( RCT.UNIT_FLAG = 'Y' OR RCT.UNIT_SECTION_FLAG = 'Y' OR RCT.UNIT_SECTION_OCCURRENCE_FLAG = 'Y' )
AND RCT.S_REFERENCE_CD_TYPE = 'STATS'