VIEW: APPS.IGC_CC_ACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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