Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGC_CC_ACCT_LINES_V |
SELECT CCAL.ROWID
, CCAL.CC_HEADER_ID
, CCHD.ORG_ID
, L.MEANING
, CCHD.CC_TYPE
, CCHD.CC_NUM
, CCAL.CC_ACCT_LINE_ID
, CCAL.CC_ACCT_LINE_NUM
, CCAL.CC_ACCT_DESC
, CCAL.PARENT_HEADER_ID
, CCAL.PARENT_ACCT_LINE_ID
, CCPAL.CC_ACCT_LINE_NUM
, GCCB.DESCRIPTION
, CCAL.CC_BUDGET_CODE_COMBINATION_ID
, GCCC.DESCRIPTION
, CCAL.CC_CHARGE_CODE_COMBINATION_ID
, CCAL.CC_ACCT_ENTERED_AMT
, CCAL.CC_ACCT_FUNC_AMT
, IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( CCAL.CC_ACCT_LINE_ID)
, IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( CCAL.CC_ACCT_LINE_ID)
, CCAL.CC_ACCT_ENCMBRNC_AMT
, ( IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT ( CCAL.CC_HEADER_ID
, NVL(CCAL.CC_ACCT_ENTERED_AMT
, 0) ) - NVL(CCAL.CC_ACCT_ENCMBRNC_AMT
, 0) ) UNENCMBRD_AMT
, CCAL.CC_ACCT_UNBILLED_AMT
, IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(CCAL.CC_HEADER_ID
, NVL(CCAL.CC_ACCT_ENTERED_AMT
, 0)) COMP_FUNC_AMT
, PPEV.PROJECT_NUMBER
, CCAL.PROJECT_ID
, PTEV.TASK_NUMBER
, CCAL.TASK_ID
, CCAL.EXPENDITURE_TYPE
, POEV.NAME
, CCAL.EXPENDITURE_ORG_ID
, CCAL.EXPENDITURE_ITEM_DATE
, CCAL.CC_ACCT_TAXABLE_FLAG
, APT.NAME
, CCAL.TAX_ID
, CCAL.CC_ACCT_ENCMBRNC_STATUS
, CCAL.CC_ACCT_ENCMBRNC_DATE
, CCAL.CONTEXT
, CCAL.ATTRIBUTE1
, CCAL.ATTRIBUTE2
, CCAL.ATTRIBUTE3
, CCAL.ATTRIBUTE4
, CCAL.ATTRIBUTE5
, CCAL.ATTRIBUTE6
, CCAL.ATTRIBUTE7
, CCAL.ATTRIBUTE8
, CCAL.ATTRIBUTE9
, CCAL.ATTRIBUTE10
, CCAL.ATTRIBUTE11
, CCAL.ATTRIBUTE12
, CCAL.ATTRIBUTE13
, CCAL.ATTRIBUTE14
, CCAL.ATTRIBUTE15
, CCAL.CREATED_BY
, CCAL.CREATION_DATE
, CCAL.LAST_UPDATED_BY
, CCAL.LAST_UPDATE_DATE
, CCAL.LAST_UPDATE_LOGIN
FROM IGC_CC_ACCT_LINES CCAL
, FND_LOOKUPS L
, IGC_CC_HEADERS CCHD
, IGC_CC_ACCT_LINES CCPAL
, GL_CODE_COMBINATIONS GCCC
, GL_CODE_COMBINATIONS GCCB
, PA_PROJECTS_EXPEND_V PPEV
, PA_TASKS_EXPEND_V PTEV
, PA_EXPENDITURE_TYPES_EXPEND_V PETEV
, PA_ORGANIZATIONS_EXPEND_V POEV
, AP_TAX_CODES_ALL APT
WHERE L.LOOKUP_TYPE (+) = 'IGC_CC_TYPE'
AND L.LOOKUP_CODE (+) = CCHD.CC_TYPE
AND CCHD.CC_HEADER_ID = CCAL.CC_HEADER_ID
AND CCPAL.CC_HEADER_ID (+) = CCAL.PARENT_HEADER_ID
AND GCCC.CODE_COMBINATION_ID (+) = CCAL.CC_CHARGE_CODE_COMBINATION_ID
AND GCCB.CODE_COMBINATION_ID (+) = CCAL.CC_BUDGET_CODE_COMBINATION_ID
AND CCPAL.CC_ACCT_LINE_ID (+) = CCAL.PARENT_ACCT_LINE_ID
AND PPEV.PROJECT_ID (+) = CCAL.PROJECT_ID
AND PTEV.TASK_ID (+) = CCAL.TASK_ID
AND PETEV.PROJECT_ID (+) = CCAL.PROJECT_ID
AND POEV.ORGANIZATION_ID (+) = CCAL.EXPENDITURE_ORG_ID
AND POEV.ACTIVE_FLAG (+) = 'Y'
AND APT.TAX_ID (+) = CCAL.TAX_ID