VIEW: APPS.IGC_CC_ACCESS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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