View: IGCBV_MC_ACCOUNT_LINES

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

View Text

SELECT IGCCAL.CC_ACCT_LINE_NUM ACCOUNT_LINE_NUMBER
, IGC_CC_MC_ACCT_LINES.CC_ACCT_FUNC_AMT ACCT_LINE_FUNCTIONAL_AMOUNT
, IGC_CC_MC_ACCT_LINES.CC_ACCT_ENCMBRNC_AMT ACCT_LINE_ENCUMBRANCE_AMOUNT
, IGC_CC_MC_ACCT_LINES.CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, IGC_CC_MC_ACCT_LINES.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, IGC_CC_MC_ACCT_LINES.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
, IGCCAL.CC_HEADER_ID CONTRACT_COMMITMENT_ID
, IGC_CC_MC_ACCT_LINES.CC_ACCT_LINE_ID ACCOUNT_LINE_ID
, IGC_CC_MC_ACCT_LINES.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM IGC_CC_ACCT_LINES IGCCAL
, IGC_CC_MC_ACCT_LINES IGC_CC_MC_ACCT_LINES
, GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
WHERE IGC_CC_MC_ACCT_LINES.CC_ACCT_LINE_ID=IGCCAL.CC_ACCT_LINE_ID
AND IGC_CC_MC_ACCT_LINES.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS. SET_OF_BOOKS_ID WITH READ ONLY

Columns