VIEW: APPS.IGC_CC_ACCT_LINE_VERSION_V

Source

View Text - Preformatted

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, CC_FUNC_WITHHELD_AMT, CC_ENT_WITHHELD_AMT, tax_classif_code 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, CC_FUNC_WITHHELD_AMT, CC_ENT_WITHHELD_AMT, tax_classif_code 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)

View Text - HTML Formatted

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
, CC_FUNC_WITHHELD_AMT
, CC_ENT_WITHHELD_AMT
, TAX_CLASSIF_CODE
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
, CC_FUNC_WITHHELD_AMT
, CC_ENT_WITHHELD_AMT
, TAX_CLASSIF_CODE
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)