VIEW: APPS.IGCBV_CC_RELEASES

Source

View Text - Preformatted

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_ALL IGC_CCH WHERE IGC_CCH.CC_TYPE = 'R' AND '_SEC:IGC_CCH.ORG_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

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_ALL IGC_CCH
WHERE IGC_CCH.CC_TYPE = 'R'
AND '_SEC:IGC_CCH.ORG_ID' IS NOT NULL WITH READ ONLY