View: IGC_CC_ACCESS_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CC_ACCESS_V

View Text

SELECT ICA.ROWID ROW_ID
, ICA.CC_HEADER_ID
, ICA.CC_ACCESS_ID
, ICA.CC_ACCESS_LEVEL
, ICA.CC_ACCESS_TYPE
, LA.MEANING
, ICG.CC_GROUP_ID
, ICG.CC_GROUP_NAME
, 0
, ' '
, ICA.LAST_UPDATE_DATE
, ICA.LAST_UPDATED_BY
, ICA.CREATION_DATE
, ICA.CREATED_BY
, ICA.LAST_UPDATE_LOGIN
FROM IGC_CC_ACCESS ICA
, IGC_CC_GROUPS ICG
, FND_LOOKUPS LA
WHERE (ICA.CC_GROUP_ID = ICG.CC_GROUP_ID
AND NVL ( ICA.USER_ID
, 0) = 0)
AND LA.LOOKUP_TYPE (+) = 'IGC_CC_ACCESS_TYPE'
AND LA.LOOKUP_CODE (+) = ICA.CC_ACCESS_TYPE UNION SELECT ICB.ROWID ROW_ID
, ICB.CC_HEADER_ID
, ICB.CC_ACCESS_ID
, ICB.CC_ACCESS_LEVEL
, ICB.CC_ACCESS_TYPE
, LB.MEANING
, 0
, ' '
, U.USER_ID
, U.USER_NAME
, ICB.LAST_UPDATE_DATE
, ICB.LAST_UPDATED_BY
, ICB.CREATION_DATE
, ICB.CREATED_BY
, ICB.LAST_UPDATE_LOGIN
FROM IGC_CC_ACCESS ICB
, FND_USER U
, FND_LOOKUPS LB
WHERE (ICB.USER_ID = U.USER_ID
AND NVL ( ICB.CC_GROUP_ID
, 0 ) = 0 )
AND LB.LOOKUP_TYPE (+) = 'IGC_CC_ACCESS_TYPE'
AND LB.LOOKUP_CODE (+) = ICB.CC_ACCESS_TYPE

Columns