VIEW: APPS.IGC_CC_CONTROL_FUNCTIONS_V

Source

View Text - Preformatted

SELECT ICF.ROWID ROW_ID, ICF.CONTROL_FUNCTION_ID, ICF.CC_TYPE, FND1.MEANING CC_TYPE_NAME, ICF.CC_STATE, FND2.MEANING CC_STATE_NAME, ICF.CONTROL_GROUP_ID, ICG.CONTROL_GROUP_NAME, ICF.JOB_ID, ICF.POSITION_ID, ICF.ORGANIZATION_ID, ICF.ORG_ID, ICF.END_DATE, ICF.START_DATE, ICF.LAST_UPDATED_BY, ICF.LAST_UPDATE_DATE, ICF.LAST_UPDATE_LOGIN, ICF.CREATION_DATE, ICF.CREATED_BY, ICF.ATTRIBUTE_CATEGORY, ICF.ATTRIBUTE1, ICF.ATTRIBUTE2, ICF.ATTRIBUTE3, ICF.ATTRIBUTE4, ICF.ATTRIBUTE5, ICF.ATTRIBUTE6, ICF.ATTRIBUTE7, ICF.ATTRIBUTE8, ICF.ATTRIBUTE9, ICF.ATTRIBUTE10, ICF.ATTRIBUTE11, ICF.ATTRIBUTE12, ICF.ATTRIBUTE13, ICF.ATTRIBUTE14, ICF.ATTRIBUTE15 FROM IGC_CC_CONTROL_FUNCTIONS_ALL ICF, IGC_CC_CONTROL_GROUPS ICG, FND_LOOKUPS FND1, FND_LOOKUPS FND2 WHERE ICF.CONTROL_GROUP_ID = ICG.CONTROL_GROUP_ID AND FND1.LOOKUP_TYPE = 'IGC_CC_TYPE' AND FND1.LOOKUP_CODE = ICF.CC_TYPE AND FND2.LOOKUP_TYPE = 'IGC_CC_STATE' AND FND2.LOOKUP_CODE = ICF.CC_STATE

View Text - HTML Formatted

SELECT ICF.ROWID ROW_ID
, ICF.CONTROL_FUNCTION_ID
, ICF.CC_TYPE
, FND1.MEANING CC_TYPE_NAME
, ICF.CC_STATE
, FND2.MEANING CC_STATE_NAME
, ICF.CONTROL_GROUP_ID
, ICG.CONTROL_GROUP_NAME
, ICF.JOB_ID
, ICF.POSITION_ID
, ICF.ORGANIZATION_ID
, ICF.ORG_ID
, ICF.END_DATE
, ICF.START_DATE
, ICF.LAST_UPDATED_BY
, ICF.LAST_UPDATE_DATE
, ICF.LAST_UPDATE_LOGIN
, ICF.CREATION_DATE
, ICF.CREATED_BY
, ICF.ATTRIBUTE_CATEGORY
, ICF.ATTRIBUTE1
, ICF.ATTRIBUTE2
, ICF.ATTRIBUTE3
, ICF.ATTRIBUTE4
, ICF.ATTRIBUTE5
, ICF.ATTRIBUTE6
, ICF.ATTRIBUTE7
, ICF.ATTRIBUTE8
, ICF.ATTRIBUTE9
, ICF.ATTRIBUTE10
, ICF.ATTRIBUTE11
, ICF.ATTRIBUTE12
, ICF.ATTRIBUTE13
, ICF.ATTRIBUTE14
, ICF.ATTRIBUTE15
FROM IGC_CC_CONTROL_FUNCTIONS_ALL ICF
, IGC_CC_CONTROL_GROUPS ICG
, FND_LOOKUPS FND1
, FND_LOOKUPS FND2
WHERE ICF.CONTROL_GROUP_ID = ICG.CONTROL_GROUP_ID
AND FND1.LOOKUP_TYPE = 'IGC_CC_TYPE'
AND FND1.LOOKUP_CODE = ICF.CC_TYPE
AND FND2.LOOKUP_TYPE = 'IGC_CC_STATE'
AND FND2.LOOKUP_CODE = ICF.CC_STATE