VIEW: APPS.IGCBV_MC_RELEASES

Source

View Text - Preformatted

SELECT IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER, IGC_CCH.CC_VERSION_NUM RELEASE_VERSION_NUMBER, IGC_CC_MC_HEADERS.CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, IGC_CC_MC_HEADERS.CONVERSION_DATE CURRENCY_CONVERSION_DATE, IGC_CC_MC_HEADERS.CONVERSION_RATE CURRENCY_CONVERSION_RATE, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME, IGC_CCH.ORG_ID ORGANIZATION_ID, IGC_CCH.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID, IGC_CC_MC_HEADERS.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID, IGC_CC_MC_HEADERS.SET_OF_BOOKS_ID SET_OF_BOOKS_ID FROM GL_SETS_OF_BOOKS_11I GL_SETS_OF_BOOKS,IGC_CC_MC_HEADERS IGC_CC_MC_HEADERS,IGC_CC_HEADERS_ALL IGC_CCH WHERE IGC_CC_MC_HEADERS.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID AND IGC_CC_MC_HEADERS.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID 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
, IGC_CC_MC_HEADERS.CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, IGC_CC_MC_HEADERS.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, IGC_CC_MC_HEADERS.CONVERSION_RATE CURRENCY_CONVERSION_RATE
, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, IGC_CCH.ORG_ID ORGANIZATION_ID
, IGC_CCH.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID
, IGC_CC_MC_HEADERS.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID
, IGC_CC_MC_HEADERS.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM GL_SETS_OF_BOOKS_11I GL_SETS_OF_BOOKS
, IGC_CC_MC_HEADERS IGC_CC_MC_HEADERS
, IGC_CC_HEADERS_ALL IGC_CCH
WHERE IGC_CC_MC_HEADERS.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID
AND IGC_CC_MC_HEADERS.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID
AND '_SEC:IGC_CCH.ORG_ID' IS NOT NULL WITH READ ONLY