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