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.

[Home] [Help]

View: IGC_CC_ACCT_LINE_VERSION_V

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

View Text

SELECT CC_ACCT_LINE_ID
, CC_HEADER_ID
, PARENT_HEADER_ID
, PARENT_ACCT_LINE_ID
, CC_ACCT_LINE_NUM
, CC_CHARGE_CODE_COMBINATION_ID
, CC_BUDGET_CODE_COMBINATION_ID
, CC_ACCT_ENTERED_AMT
, CC_ACCT_FUNC_AMT
, CC_ACCT_DESC
, CC_ACCT_TAXABLE_FLAG
, TAX_ID
, CC_ACCT_ENCMBRNC_AMT
, CC_ACCT_ENCMBRNC_STATUS
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ORG_ID
, EXPENDITURE_ITEM_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CC_ACCT_ENCMBRNC_DATE
FROM IGC_CC_ACCT_LINES
WHERE (CC_ACCT_LINE_ID) IN (SELECT CC_ACCT_LINE_ID
FROM IGC_CC_ACCT_LINES MINUS SELECT CC_ACCT_LINE_ID
FROM IGC_CC_ACCT_LINE_HISTORY
WHERE (CC_ACCT_LINE_ID
, CC_ACCT_VERSION_NUM) IN (SELECT CC_ACCT_LINE_ID
, MIN(CC_ACCT_VERSION_NUM)
FROM IGC_CC_ACCT_LINE_HISTORY
WHERE CC_ACCT_VERSION_NUM >= IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM GROUP BY CC_ACCT_LINE_ID)) UNION SELECT CC_ACCT_LINE_ID
, CC_HEADER_ID
, PARENT_HEADER_ID
, PARENT_ACCT_LINE_ID
, CC_ACCT_LINE_NUM
, CC_CHARGE_CODE_COMBINATION_ID
, CC_BUDGET_CODE_COMBINATION_ID
, CC_ACCT_ENTERED_AMT
, CC_ACCT_FUNC_AMT
, CC_ACCT_DESC
, CC_ACCT_TAXABLE_FLAG
, TAX_ID
, CC_ACCT_ENCMBRNC_AMT
, CC_ACCT_ENCMBRNC_STATUS
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ORG_ID
, EXPENDITURE_ITEM_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CC_ACCT_ENCMBRNC_DATE
FROM IGC_CC_ACCT_LINE_HISTORY
WHERE (CC_ACCT_LINE_ID
, CC_ACCT_VERSION_NUM) IN (SELECT CC_ACCT_LINE_ID
, MIN(CC_ACCT_VERSION_NUM)
FROM IGC_CC_ACCT_LINE_HISTORY
WHERE CC_ACCT_VERSION_NUM >= IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM
AND CC_ACCT_VERSION_ACTION <> 'I' GROUP BY CC_ACCT_LINE_ID)

Columns

Name
CC_ACCT_LINE_ID
CC_HEADER_ID
PARENT_HEADER_ID
PARENT_ACCT_LINE_ID
CC_ACCT_LINE_NUM
CC_CHARGE_CODE_COMBINATION_ID
CC_BUDGET_CODE_COMBINATION_ID
CC_ACCT_ENTERED_AMT
CC_ACCT_FUNC_AMT
CC_ACCT_DESC
CC_ACCT_TAXABLE_FLAG
TAX_ID
CC_ACCT_ENCMBRNC_AMT
CC_ACCT_ENCMBRNC_STATUS
PROJECT_ID
TASK_ID
EXPENDITURE_TYPE
EXPENDITURE_ORG_ID
EXPENDITURE_ITEM_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CC_ACCT_ENCMBRNC_DATE