Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGC_CC_CONTROL_FUNCTIONS_V |
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_WF_CONTROL_FUNCTIONS ICF
, IGC_CC_WF_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