View: IGC_CC_ACTIONS_V

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

View Text

SELECT CCA.ROWID ROW_ID
, CCA.CC_HEADER_ID
, CCA.CC_ACTION_NUM
, CCA.CC_ACTION_VERSION_NUM
, CCA.CC_ACTION_TYPE
, LKP1.MEANING CC_ACTION_TYPE_DESC
, CCA.CC_ACTION_STATE
, LKP2.MEANING CC_ACTION_STATE_DESC
, CCA.CC_ACTION_CTRL_STATUS
, LKP3.MEANING CC_ACTION_CTRL_STATUS_DESC
, CCA.CC_ACTION_APPRVL_STATUS
, LKP4.MEANING CC_ACTION_APPRVL_STATUS_DESC
, CCA.CC_ACTION_NOTES
, CCA.LAST_UPDATE_DATE
, CCA.LAST_UPDATED_BY
, CCA.LAST_UPDATE_LOGIN
, CCA.CREATION_DATE
, CCA.CREATED_BY
, FNDU.USER_NAME
FROM IGC_CC_ACTIONS CCA
, FND_LOOKUPS LKP1
, FND_LOOKUPS LKP2
, FND_LOOKUPS LKP3
, FND_LOOKUPS LKP4
, FND_USER FNDU
WHERE FNDU.USER_ID = CCA.CREATED_BY
AND LKP1.LOOKUP_TYPE(+) = 'IGC_CC_ACTION_TYPE'
AND LKP1.LOOKUP_CODE(+) = CCA.CC_ACTION_TYPE
AND LKP2.LOOKUP_TYPE(+) = 'IGC_CC_STATE'
AND LKP2.LOOKUP_CODE(+) = CCA.CC_ACTION_STATE
AND LKP3.LOOKUP_TYPE(+) = 'IGC_CC_CONTROL_STATUS'
AND LKP3.LOOKUP_CODE(+) = CCA.CC_ACTION_CTRL_STATUS
AND LKP4.LOOKUP_TYPE(+) = 'IGC_CC_APPROVAL_STATUS'
AND LKP4.LOOKUP_CODE(+) = CCA.CC_ACTION_APPRVL_STATUS

Columns