VIEW: APPS.IGS_SC_GRANT_CONDS_V

Source

View Text - Preformatted

SELECT Grn.OBJ_GROUP_ID, gr.GRANT_ID , gr.GRANT_COND_NUM , gr.OBJ_ATTRIB_ID , obat.OBJ_ATTRIB_NAME , gr.USER_ATTRIB_ID , usat.USER_ATTRIB_NAME , gr.CONDITION , gr.TEXT_VALUE , gr.CREATION_DATE , gr.CREATED_BY , gr.LAST_UPDATED_BY , gr.LAST_UPDATE_DATE , gr.LAST_UPDATE_LOGIN FROM igs_sc_grant_conds gr, Igs_sc_grants grn, igs_sc_usr_attribs usat, igs_sc_obj_attribs obat WHERE gr.USER_ATTRIB_ID = usat.USER_ATTRIB_ID (+) AND grn.GRANT_ID = gr.GRANT_ID AND gr.OBJ_ATTRIB_ID = obat.OBJ_ATTRIB_ID (+) AND grn.OBJ_GROUP_ID = NVL(obat.OBJ_GROUP_ID,grn.OBJ_GROUP_ID)

View Text - HTML Formatted

SELECT GRN.OBJ_GROUP_ID
, GR.GRANT_ID
, GR.GRANT_COND_NUM
, GR.OBJ_ATTRIB_ID
, OBAT.OBJ_ATTRIB_NAME
, GR.USER_ATTRIB_ID
, USAT.USER_ATTRIB_NAME
, GR.CONDITION
, GR.TEXT_VALUE
, GR.CREATION_DATE
, GR.CREATED_BY
, GR.LAST_UPDATED_BY
, GR.LAST_UPDATE_DATE
, GR.LAST_UPDATE_LOGIN
FROM IGS_SC_GRANT_CONDS GR
, IGS_SC_GRANTS GRN
, IGS_SC_USR_ATTRIBS USAT
, IGS_SC_OBJ_ATTRIBS OBAT
WHERE GR.USER_ATTRIB_ID = USAT.USER_ATTRIB_ID (+)
AND GRN.GRANT_ID = GR.GRANT_ID
AND GR.OBJ_ATTRIB_ID = OBAT.OBJ_ATTRIB_ID (+)
AND GRN.OBJ_GROUP_ID = NVL(OBAT.OBJ_GROUP_ID
, GRN.OBJ_GROUP_ID)