VIEW: APPS.IGCBV_CC_ACTION_HISTORIES

Source

View Text - Preformatted

SELECT IGC_CCA.CC_ACTION_NUM ACTION_NUMBER, '_LA:CC_ACTION_TYPE:FND_LOOKUPS:IGC_CC_ACTION_TYPE:MEANING' "_LA:ACTION_TYPE", '_LA:CC_ACTION_STATE:FND_LOOKUPS:IGC_CC_STATE:MEANING' "_LA:ACTION_STATE", '_LA:CC_ACTION_CTRL_STATUS:FND_LOOKUPS:IGC_CC_CONTROL_STATUS:MEANING' "_LA:ACTION_CONTROL_STATUS", '_LA:CC_ACTION_APPRVL_STATUS:FND_LOOKUPS:IGC_CC_APPROVAL_STATUS:MEANING' "_LA:ACTION_APPROVAL_STATUS", IGC_CCA.CC_ACTION_NOTES ACTION_NOTES, IGC_CCH.CC_NUM CONTRACT_COMMITMENT_NUMBER, IGC_CCH.CC_VERSION_NUM CONTRACT_VERSION_NUMBER, IGC_CCA.CC_HEADER_ID CONTRACT_COMMITMENT_ID, IGC_CCA.LAST_UPDATE_DATE LAST_UPDATE_DATE, IGC_CCA.LAST_UPDATED_BY LAST_UPDATED_BY, IGC_CCA.CREATION_DATE CREATION_DATE, IGC_CCA.CREATED_BY CREATED_BY FROM IGC_CC_ACTIONS IGC_CCA,IGC_CC_HEADERS_ALL IGC_CCH WHERE IGC_CCA.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID WITH READ ONLY

View Text - HTML Formatted

SELECT IGC_CCA.CC_ACTION_NUM ACTION_NUMBER
, '_LA:CC_ACTION_TYPE:FND_LOOKUPS:IGC_CC_ACTION_TYPE:MEANING' "_LA:ACTION_TYPE"
, '_LA:CC_ACTION_STATE:FND_LOOKUPS:IGC_CC_STATE:MEANING' "_LA:ACTION_STATE"
, '_LA:CC_ACTION_CTRL_STATUS:FND_LOOKUPS:IGC_CC_CONTROL_STATUS:MEANING' "_LA:ACTION_CONTROL_STATUS"
, '_LA:CC_ACTION_APPRVL_STATUS:FND_LOOKUPS:IGC_CC_APPROVAL_STATUS:MEANING' "_LA:ACTION_APPROVAL_STATUS"
, IGC_CCA.CC_ACTION_NOTES ACTION_NOTES
, IGC_CCH.CC_NUM CONTRACT_COMMITMENT_NUMBER
, IGC_CCH.CC_VERSION_NUM CONTRACT_VERSION_NUMBER
, IGC_CCA.CC_HEADER_ID CONTRACT_COMMITMENT_ID
, IGC_CCA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IGC_CCA.LAST_UPDATED_BY LAST_UPDATED_BY
, IGC_CCA.CREATION_DATE CREATION_DATE
, IGC_CCA.CREATED_BY CREATED_BY
FROM IGC_CC_ACTIONS IGC_CCA
, IGC_CC_HEADERS_ALL IGC_CCH
WHERE IGC_CCA.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID WITH READ ONLY