View: IGCFV_MC_CONTRACT_COMMITMENTS

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

View Text

SELECT IGC_CCH.CC_NUM CONTRACT_COMMITMENT_NUMBER
, IGC_CCH.CC_VERSION_NUM CONTRACT_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_DAILY_CONVERSION_TYPES.USER_CONVERSION_TYPE RATE_NAME
, GL_DAILY_CONVERSION_TYPES.DESCRIPTION RATE_DESCRIPTION
, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, ORU.NAME ORGANIZATION_NAME
, IGC_CCH.ORG_ID ORGANIZATION_ID
, IGC_CC_MC_HEADERS.CC_HEADER_ID CONTRACT_COMMITMENT_ID
, IGC_CC_MC_HEADERS.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
, HR_ALL_ORGANIZATION_UNITS ORU
, IGC_CC_MC_HEADERS IGC_CC_MC_HEADERS
, IGC_CC_HEADERS IGC_CCH
, GL_DAILY_CONVERSION_TYPES GL_DAILY_CONVERSION_TYPES
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 IGC_CCH.ORG_ID=ORU.ORGANIZATION_ID
AND IGC_CC_MC_HEADERS.CONVERSION_TYPE=GL_DAILY_CONVERSION_TYPES. USER_CONVERSION_TYPE (+)
AND '_SEC:IGC_CCH.ORG_ID' IS NOT NULL WITH READ ONLY

Columns