View: IGCBV_CC_RELEASES

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

View Text

SELECT IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER
, IGC_CCH.CC_VERSION_NUM RELEASE_VERSION_NUMBER
, '_LA:CC_CTRL_STATUS:FND_LOOKUPS:IGC_CC_CONTROL_STATUS:MEANING' "_LA:RELEASE_CONTROL_STATUS"
, '_LA:CC_APPRVL_STATUS:FND_LOOKUPS:IGC_CC_APPROVAL_STATUS:MEANING' "_LA:RELEASE_APPROVAL_STATUS"
, '_LA:CC_TYPE:FND_LOOKUPS:IGC_CC_TYPE:MEANING' "_LA:TYPE"
, '_LA:CC_STATE:FND_LOOKUPS:IGC_CC_STATE:MEANING' "_LA:STATE"
, IGC_CCH.CC_DESC DESCRIPTION
, IGC_CCH.CC_START_DATE START_EFFECTIVE_DATE
, IGC_CCH.CC_END_DATE END_EFFECTIVE_DATE
, IGC_CCH.ORG_ID ORGANIZATION_ID
, IGC_CCH.VENDOR_ID VENDOR_ID
, IGC_CCH.VENDOR_SITE_ID VENDOR_SITE_ID
, IGC_CCH.VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, IGC_CCH.TERM_ID TERM_ID
, IGC_CCH.LOCATION_ID LOCATION_ID
, IGC_CCH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, IGC_CCH.CURRENCY_CODE CURRENCY_CODE
, IGC_CCH.CONVERSION_TYPE CONVERSION_TYPE
, IGC_CCH.CC_PREPARER_USER_ID PREPARER_USER_ID
, IGC_CCH.CC_OWNER_USER_ID OWNER_USER_ID
, IGC_CCH.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID
, IGC_CCH.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID
, IGC_CCH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IGC_CCH.LAST_UPDATED_BY LAST_UPDATED_BY
, IGC_CCH.CREATED_BY CREATED_BY
, IGC_CCH.CREATION_DATE CREATION_DATE
FROM IGC_CC_HEADERS IGC_CCH
WHERE IGC_CCH.CC_TYPE = 'R'
AND '_SEC:IGC_CCH.ORG_ID' IS NOT NULL WITH READ ONLY

Columns