eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGCFV_MC_ACCOUNT_LINES

Source

View Text - Preformatted


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, IGC_CCH.CC_NUM CONTRACT_COMMITMENT_NUMBER, 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_11I GL_SETS_OF_BOOKS,IGC_CC_HEADERS_ALL IGC_CCH 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 AND IGCCAL.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID WITH READ ONLY

View Text - HTML Formatted

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
, IGC_CCH.CC_NUM CONTRACT_COMMITMENT_NUMBER
, 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_11I GL_SETS_OF_BOOKS
, IGC_CC_HEADERS_ALL IGC_CCH
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
AND IGCCAL.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID WITH READ ONLY