VIEW: APPS.IGCFV_CC_RELEASES

Source

View Text - Preformatted

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:IGC_CCH.CC_CTRL_STATUS:FND_LOOKUPS:IGC_CC_CONTROL_STATUS:MEANING' , '_LA:IGC_CCH.CC_STATE:FND_LOOKUPS:IGC_CC_STATE:MEANING', '_LA:IGC_CCH.CC_TYPE:FND_LOOKUPS:IGC_CC_TYPE:MEANING' , 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' , 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_ALL IGC_CCH,IGC_CC_HEADERS_ALL 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_11I 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

View Text - HTML Formatted

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:IGC_CCH.CC_CTRL_STATUS:FND_LOOKUPS:IGC_CC_CONTROL_STATUS:MEANING'
, '_LA:IGC_CCH.CC_STATE:FND_LOOKUPS:IGC_CC_STATE:MEANING'
, '_LA:IGC_CCH.CC_TYPE:FND_LOOKUPS:IGC_CC_TYPE:MEANING'
, 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'
, 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_ALL IGC_CCH
, IGC_CC_HEADERS_ALL 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_11I 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