VIEW: APPS.IGC_CC_DET_PF_VERSION_V

Source

View Text - Preformatted

SELECT CC_DET_PF_LINE_ID, CC_DET_PF_LINE_NUM, CC_ACCT_LINE_ID, PARENT_ACCT_LINE_ID, PARENT_DET_PF_LINE_ID, CC_DET_PF_ENTERED_AMT, CC_DET_PF_FUNC_AMT, CC_DET_PF_DATE, CC_DET_PF_ENCMBRNC_AMT, CC_DET_PF_ENCMBRNC_DATE, CC_DET_PF_ENCMBRNC_STATUS, 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 FROM IGC_CC_DET_PF WHERE CC_DET_PF_LINE_ID IN (SELECT CC_DET_PF_LINE_ID FROM IGC_CC_DET_PF MINUS SELECT CC_DET_PF_LINE_ID FROM IGC_CC_DET_PF_HISTORY WHERE (CC_DET_PF_LINE_ID, CC_DET_PF_VERSION_NUM) IN (SELECT CC_DET_PF_LINE_ID, MIN(CC_DET_PF_VERSION_NUM) FROM IGC_CC_DET_PF_HISTORY WHERE CC_DET_PF_VERSION_NUM >= IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM GROUP BY CC_DET_PF_LINE_ID)) UNION SELECT CC_DET_PF_LINE_ID, CC_DET_PF_LINE_NUM, CC_ACCT_LINE_ID, PARENT_ACCT_LINE_ID, PARENT_DET_PF_LINE_ID, CC_DET_PF_ENTERED_AMT, CC_DET_PF_FUNC_AMT, CC_DET_PF_DATE, CC_DET_PF_ENCMBRNC_AMT, CC_DET_PF_ENCMBRNC_DATE, CC_DET_PF_ENCMBRNC_STATUS, 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 FROM IGC_CC_DET_PF_HISTORY WHERE (CC_DET_PF_LINE_ID, CC_DET_PF_VERSION_NUM) IN (SELECT CC_DET_PF_LINE_ID, MIN(CC_DET_PF_VERSION_NUM) FROM IGC_CC_DET_PF_HISTORY WHERE CC_DET_PF_VERSION_NUM >= IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM AND CC_DET_PF_VERSION_ACTION <> 'I' GROUP BY CC_DET_PF_LINE_ID)

View Text - HTML Formatted

SELECT CC_DET_PF_LINE_ID
, CC_DET_PF_LINE_NUM
, CC_ACCT_LINE_ID
, PARENT_ACCT_LINE_ID
, PARENT_DET_PF_LINE_ID
, CC_DET_PF_ENTERED_AMT
, CC_DET_PF_FUNC_AMT
, CC_DET_PF_DATE
, CC_DET_PF_ENCMBRNC_AMT
, CC_DET_PF_ENCMBRNC_DATE
, CC_DET_PF_ENCMBRNC_STATUS
, 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
FROM IGC_CC_DET_PF
WHERE CC_DET_PF_LINE_ID IN (SELECT CC_DET_PF_LINE_ID
FROM IGC_CC_DET_PF MINUS SELECT CC_DET_PF_LINE_ID
FROM IGC_CC_DET_PF_HISTORY
WHERE (CC_DET_PF_LINE_ID
, CC_DET_PF_VERSION_NUM) IN (SELECT CC_DET_PF_LINE_ID
, MIN(CC_DET_PF_VERSION_NUM)
FROM IGC_CC_DET_PF_HISTORY
WHERE CC_DET_PF_VERSION_NUM >= IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM GROUP BY CC_DET_PF_LINE_ID)) UNION SELECT CC_DET_PF_LINE_ID
, CC_DET_PF_LINE_NUM
, CC_ACCT_LINE_ID
, PARENT_ACCT_LINE_ID
, PARENT_DET_PF_LINE_ID
, CC_DET_PF_ENTERED_AMT
, CC_DET_PF_FUNC_AMT
, CC_DET_PF_DATE
, CC_DET_PF_ENCMBRNC_AMT
, CC_DET_PF_ENCMBRNC_DATE
, CC_DET_PF_ENCMBRNC_STATUS
, 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
FROM IGC_CC_DET_PF_HISTORY
WHERE (CC_DET_PF_LINE_ID
, CC_DET_PF_VERSION_NUM) IN (SELECT CC_DET_PF_LINE_ID
, MIN(CC_DET_PF_VERSION_NUM)
FROM IGC_CC_DET_PF_HISTORY
WHERE CC_DET_PF_VERSION_NUM >= IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM
AND CC_DET_PF_VERSION_ACTION <> 'I' GROUP BY CC_DET_PF_LINE_ID)