Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGCBV_CC_ACTION_HISTORIES |
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 IGC_CCH
WHERE IGC_CCA.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID WITH READ ONLY