VIEW: APPS.IGCFV_MC_RELEASE_ACCOUNT_LINES

Source

View Text - Preformatted

SELECT IGCCAL.CC_ACCT_LINE_NUM RELEASE_ACCOUNT_LINE_NUMBER, IGC_CC_MC_ACCT_LINES.CC_ACCT_FUNC_AMT RELEASE_ACCT_FUNCTIONAL_AMOUNT, IGC_CC_MC_ACCT_LINES.CC_ACCT_ENCMBRNC_AMT REL_ACCT_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, IGCCALP.CC_ACCT_LINE_NUM PARENT_ACCOUNT_LINE_NUMBER, IGC_CCHP.CC_NUM PARENT_CONTRACT_NUMBER, IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER, IGCCAL.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID, IGCCAL.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_ID, IGCCAL.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID, IGC_CC_MC_ACCT_LINES.CC_ACCT_LINE_ID RELEASE_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,IGC_CC_ACCT_LINES IGCCALP,IGC_CC_HEADERS_ALL IGC_CCHP 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 AND IGCCAL.PARENT_HEADER_ID=IGC_CCHP.CC_HEADER_ID AND IGCCAL.PARENT_ACCT_LINE_ID=IGCCALP.CC_ACCT_LINE_ID AND IGC_CCH.CC_TYPE = 'R' WITH READ ONLY

View Text - HTML Formatted

SELECT IGCCAL.CC_ACCT_LINE_NUM RELEASE_ACCOUNT_LINE_NUMBER
, IGC_CC_MC_ACCT_LINES.CC_ACCT_FUNC_AMT RELEASE_ACCT_FUNCTIONAL_AMOUNT
, IGC_CC_MC_ACCT_LINES.CC_ACCT_ENCMBRNC_AMT REL_ACCT_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
, IGCCALP.CC_ACCT_LINE_NUM PARENT_ACCOUNT_LINE_NUMBER
, IGC_CCHP.CC_NUM PARENT_CONTRACT_NUMBER
, IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER
, IGCCAL.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID
, IGCCAL.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_ID
, IGCCAL.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID
, IGC_CC_MC_ACCT_LINES.CC_ACCT_LINE_ID RELEASE_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
, IGC_CC_ACCT_LINES IGCCALP
, IGC_CC_HEADERS_ALL IGC_CCHP
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
AND IGCCAL.PARENT_HEADER_ID=IGC_CCHP.CC_HEADER_ID
AND IGCCAL.PARENT_ACCT_LINE_ID=IGCCALP.CC_ACCT_LINE_ID
AND IGC_CCH.CC_TYPE = 'R' WITH READ ONLY