Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGC_CC_ACCT_LINE_VERSION_V |
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)