View: IGCFV_CC_RELEASES

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

View Text

SELECT IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER
, IGC_CCH.CC_VERSION_NUM RELEASE_VERSION_NUMBER
, '_LA:IGC_CCH.CC_APPRVL_STATUS:FND_LOOKUPS:IGC_CC_APPROVAL_STATUS:MEANING' "_LA:RELEASE_APPROVAL_STATUS"
, '_LA:IGC_CCH.CC_CTRL_STATUS:FND_LOOKUPS:IGC_CC_CONTROL_STATUS:MEANING' "_LA:RELEASE_CONTROL_STATUS"
, '_LA:IGC_CCH.CC_STATE:FND_LOOKUPS:IGC_CC_STATE:MEANING' "_LA:STATE"
, '_LA:IGC_CCH.CC_TYPE:FND_LOOKUPS:IGC_CC_TYPE:MEANING' "_LA:TYPE"
, IGC_CCH.CC_DESC DESCRIPTION
, IGC_CCH.CC_START_DATE START_EFFECTIVE_DATE
, IGC_CCH.CC_END_DATE END_EFFECTIVE_DATE
, '_DF:IGC:IGC_CC_HEADERS:IGC_CCH' "_DF"
, FND_USER.USER_NAME USER_NAME
, AP_TERMS_TL.NAME TERMS_NAME
, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, GL_DAILY_CONVERSION_TYPES.USER_CONVERSION_TYPE CONVERSION_USER_TYPES
, LOC.LOCATION_CODE LOCATION_CODE
, ORU.NAME ORGANIZATION_NAME
, IGC_CCHP.CC_NUM PARENT_CONTRACT_NUMBER
, PO_VENDORS.VENDOR_NAME VENDOR_NAME
, PO_VENDORS.SEGMENT1 VENDORS_NUMBER
, PO_VENDOR_CONTACTS.LAST_NAME VENDOR_CONTACTS_LAST_NAME
, PO_VENDOR_CONTACTS.FIRST_NAME VENDOR_CONTACTS_FIRST_NAME
, PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE VENDOR_SITES_CODE
, IGC_CCH.CURRENCY_CODE CURRENCY_CODE
, IGC_CCH.CONVERSION_TYPE CONVERSION_TYPE
, IGC_CCH.ORG_ID ORGANIZATION_ID
, IGC_CCH.TERM_ID TERM_ID
, IGC_CCH.VENDOR_SITE_ID VENDOR_SITE_ID
, IGC_CCH.VENDOR_ID VENDOR_ID
, IGC_CCH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, IGC_CCH.VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, IGC_CCH.LOCATION_ID LOCATION_ID
, IGC_CCH.CC_OWNER_USER_ID OWNER_USER_ID
, IGC_CCH.CC_PREPARER_USER_ID PREPARER_USER_ID
, IGC_CCH.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID
, IGC_CCH.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID
, IGC_CCH.CREATED_BY CREATED_BY
, IGC_CCH.CREATION_DATE CREATION_DATE
, IGC_CCH.LAST_UPDATED_BY LAST_UPDATED_BY
, IGC_CCH.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGC_CC_HEADERS IGC_CCH
, IGC_CC_HEADERS IGC_CCHP
, HR_ALL_ORGANIZATION_UNITS ORU
, PO_VENDOR_CONTACTS PO_VENDOR_CONTACTS
, PO_VENDOR_SITES_ALL PO_VENDOR_SITES_ALL
, PO_VENDORS PO_VENDORS
, AP_TERMS_TL AP_TERMS_TL
, HR_LOCATIONS_ALL LOC
, GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
, GL_DAILY_CONVERSION_TYPES GL_DAILY_CONVERSION_TYPES
, FND_USER FND_USER
WHERE IGC_CCH.ORG_ID=ORU.ORGANIZATION_ID
AND IGC_CCH.VENDOR_ID=PO_VENDORS.VENDOR_ID (+)
AND IGC_CCH.VENDOR_SITE_ID=PO_VENDOR_SITES_ALL.VENDOR_SITE_ID (+)
AND IGC_CCH.VENDOR_CONTACT_ID=PO_VENDOR_CONTACTS.VENDOR_CONTACT_ID (+)
AND IGC_CCH.TERM_ID=AP_TERMS_TL.TERM_ID (+)
AND IGC_CCH.LOCATION_ID=LOC.LOCATION_ID (+)
AND IGC_CCH.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID
AND IGC_CCH.CONVERSION_TYPE=GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE (+)
AND IGC_CCH.CC_OWNER_USER_ID=FND_USER.USER_ID (+)
AND IGC_CCH.CC_PREPARER_USER_ID=FND_USER.USER_ID (+)
AND IGC_CCH.PARENT_HEADER_ID=IGC_CCHP.CC_HEADER_ID
AND IGC_CCH.CC_TYPE = 'R'
AND '_SEC:IGC_CCH.ORG_ID' IS NOT NULL WITH READ ONLY

Columns