VIEW: APPS.IGS_PS_UNIT_OFR_OPT_ASS_PAT_V

Source

View Text - Preformatted

SELECT uoo.unit_cd, uoo.version_number, uoo.cal_type, uoo.ci_sequence_number, uap.ass_pattern_cd, uap.description, uoo.location_cd, uoo.unit_class, uc.unit_mode, uoo.uoo_id, uap.ass_pattern_id, uap.logical_delete_dt, uap.created_by, uap.creation_date, uap.last_updated_by, uap.last_update_date, uap.last_update_login FROM IGS_AS_UNTAS_PATTERN uap, IGS_PS_UNIT_OFR_OPT uoo, IGS_AS_UNIT_CLASS uc WHERE uoo.unit_cd = uap.unit_cd AND uoo.version_number = uap.version_number AND uoo.cal_type = uap.cal_type AND uoo.ci_sequence_number = uap.ci_sequence_number AND uoo.unit_class = uc.unit_class AND IGS_AS_VAL_UAI.assp_val_sua_uai(uoo.location_cd, uoo.unit_class, uc.unit_mode, uap.location_cd, uap.unit_class, uap.unit_mode) = 'TRUE'

View Text - HTML Formatted

SELECT UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, UAP.ASS_PATTERN_CD
, UAP.DESCRIPTION
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
, UC.UNIT_MODE
, UOO.UOO_ID
, UAP.ASS_PATTERN_ID
, UAP.LOGICAL_DELETE_DT
, UAP.CREATED_BY
, UAP.CREATION_DATE
, UAP.LAST_UPDATED_BY
, UAP.LAST_UPDATE_DATE
, UAP.LAST_UPDATE_LOGIN
FROM IGS_AS_UNTAS_PATTERN UAP
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_AS_UNIT_CLASS UC
WHERE UOO.UNIT_CD = UAP.UNIT_CD
AND UOO.VERSION_NUMBER = UAP.VERSION_NUMBER
AND UOO.CAL_TYPE = UAP.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = UAP.CI_SEQUENCE_NUMBER
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND IGS_AS_VAL_UAI.ASSP_VAL_SUA_UAI(UOO.LOCATION_CD
, UOO.UNIT_CLASS
, UC.UNIT_MODE
, UAP.LOCATION_CD
, UAP.UNIT_CLASS
, UAP.UNIT_MODE) = 'TRUE'