eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGC_CC_ACCT_LINES_V

Source

View Text - Preformatted


SELECT ccal.ROWID ROW_ID, ccal.cc_header_id CC_HEADER_ID, cchd.org_id ORG_ID, l.meaning CC_TYPE, cchd.cc_type CC_TYPE_CODE, cchd.cc_num CC_NUM, ccal.cc_acct_line_id CC_ACCT_LINE_ID, ccal.cc_acct_line_num CC_ACCT_LINE_NUM, ccal.cc_acct_desc CC_ACCT_DESC, ccal.parent_header_id PARENT_HEADER_ID, ccal.parent_acct_line_id PARENT_ACCT_LINE_ID, ccpal.cc_acct_line_num PARENT_CC_ACCT_LINE_NUM, gccb.description CC_BUDGET_ACCT_DESC, ccal.cc_budget_code_combination_id CC_BUDGET_CODE_COMBINATION_ID, gccc.description CC_CHARGE_ACCT_DESC, ccal.cc_charge_code_combination_id CC_CHARGE_CODE_COMBINATION_ID, ccal.cc_acct_entered_amt CC_ACCT_ENTERED_AMT, ccal.cc_acct_func_amt CC_ACCT_FUNC_AMT, IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id) CC_ACCT_BILLED_AMT, IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id) CC_ACCT_FUNC_BILLED_AMT, ccal.cc_acct_encmbrnc_amt 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) ) CC_ACCT_UNENCMBRD_AMT, ccal.cc_acct_unbilled_amt CC_ACCT_UNBILLED_AMT, IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id, NVL(ccal.cc_acct_entered_amt,0)) CC_ACCT_COMP_FUNC_AMT, ppev.segment1 PROJECT_NUMBER, ccal.project_id PROJECT_ID, ptev.task_number TASK_NUMBER, ccal.task_id TASK_ID, ccal.expenditure_type EXPENDITURE_TYPE, poev.name EXPENDITURE_ORG_NAME, ccal.expenditure_org_id EXPENDITURE_ORG_ID, ccal.expenditure_item_date EXPENDITURE_ITEM_DATE, ccal.cc_acct_taxable_flag CC_ACCT_TAXABLE_FLAG, ccal.Tax_Classif_Code TAX_NAME, ccal.tax_id TAX_ID, ccal.cc_acct_encmbrnc_status CC_ACCT_ENCMBRNC_STATUS, ccal.cc_acct_encmbrnc_date CC_ACCT_ENCMBRNC_DATE, ccal.context CONTEXT, ccal.attribute1 ATTRIBUTE1, ccal.attribute2 ATTRIBUTE2, ccal.attribute3 ATTRIBUTE3, ccal.attribute4 ATTRIBUTE4, ccal.attribute5 ATTRIBUTE5, ccal.attribute6 ATTRIBUTE6, ccal.attribute7 ATTRIBUTE7, ccal.attribute8 ATTRIBUTE8, ccal.attribute9 ATTRIBUTE9, ccal.attribute10 ATTRIBUTE10, ccal.attribute11 ATTRIBUTE11, ccal.attribute12 ATTRIBUTE12, ccal.attribute13 ATTRIBUTE13, ccal.attribute14 ATTRIBUTE14, ccal.attribute15 ATTRIBUTE15, ccal.created_by CREATED_BY, ccal.creation_date CREATION_DATE, ccal.last_updated_by LAST_UPDATED_BY, ccal.last_update_date LAST_UPDATE_DATE, ccal.last_update_login LAST_UPDATE_LOGIN, ccal.cc_func_withheld_amt CC_FUNC_WITHHELD_AMT, ccal.cc_ent_withheld_amt CC_ENT_WITHHELD_AMT, IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(ccal.cc_header_id, NVL(ccal.cc_func_withheld_amt,0)) CC_COMP_FUNC_WHLD_AMT, ccal.Tax_Classif_Code TAX_CLASSIF_CODE 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_all ppev, pa_tasks ptev, hr_all_organization_units_tl poev 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 poev.organization_id (+) = ccal.expenditure_org_id AND poev.language (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT CCAL.ROWID ROW_ID
, CCAL.CC_HEADER_ID CC_HEADER_ID
, CCHD.ORG_ID ORG_ID
, L.MEANING CC_TYPE
, CCHD.CC_TYPE CC_TYPE_CODE
, CCHD.CC_NUM CC_NUM
, CCAL.CC_ACCT_LINE_ID CC_ACCT_LINE_ID
, CCAL.CC_ACCT_LINE_NUM CC_ACCT_LINE_NUM
, CCAL.CC_ACCT_DESC CC_ACCT_DESC
, CCAL.PARENT_HEADER_ID PARENT_HEADER_ID
, CCAL.PARENT_ACCT_LINE_ID PARENT_ACCT_LINE_ID
, CCPAL.CC_ACCT_LINE_NUM PARENT_CC_ACCT_LINE_NUM
, GCCB.DESCRIPTION CC_BUDGET_ACCT_DESC
, CCAL.CC_BUDGET_CODE_COMBINATION_ID CC_BUDGET_CODE_COMBINATION_ID
, GCCC.DESCRIPTION CC_CHARGE_ACCT_DESC
, CCAL.CC_CHARGE_CODE_COMBINATION_ID CC_CHARGE_CODE_COMBINATION_ID
, CCAL.CC_ACCT_ENTERED_AMT CC_ACCT_ENTERED_AMT
, CCAL.CC_ACCT_FUNC_AMT CC_ACCT_FUNC_AMT
, IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( CCAL.CC_ACCT_LINE_ID) CC_ACCT_BILLED_AMT
, IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( CCAL.CC_ACCT_LINE_ID) CC_ACCT_FUNC_BILLED_AMT
, CCAL.CC_ACCT_ENCMBRNC_AMT 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) ) CC_ACCT_UNENCMBRD_AMT
, CCAL.CC_ACCT_UNBILLED_AMT CC_ACCT_UNBILLED_AMT
, IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(CCAL.CC_HEADER_ID
, NVL(CCAL.CC_ACCT_ENTERED_AMT
, 0)) CC_ACCT_COMP_FUNC_AMT
, PPEV.SEGMENT1 PROJECT_NUMBER
, CCAL.PROJECT_ID PROJECT_ID
, PTEV.TASK_NUMBER TASK_NUMBER
, CCAL.TASK_ID TASK_ID
, CCAL.EXPENDITURE_TYPE EXPENDITURE_TYPE
, POEV.NAME EXPENDITURE_ORG_NAME
, CCAL.EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, CCAL.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, CCAL.CC_ACCT_TAXABLE_FLAG CC_ACCT_TAXABLE_FLAG
, CCAL.TAX_CLASSIF_CODE TAX_NAME
, CCAL.TAX_ID TAX_ID
, CCAL.CC_ACCT_ENCMBRNC_STATUS CC_ACCT_ENCMBRNC_STATUS
, CCAL.CC_ACCT_ENCMBRNC_DATE CC_ACCT_ENCMBRNC_DATE
, CCAL.CONTEXT CONTEXT
, CCAL.ATTRIBUTE1 ATTRIBUTE1
, CCAL.ATTRIBUTE2 ATTRIBUTE2
, CCAL.ATTRIBUTE3 ATTRIBUTE3
, CCAL.ATTRIBUTE4 ATTRIBUTE4
, CCAL.ATTRIBUTE5 ATTRIBUTE5
, CCAL.ATTRIBUTE6 ATTRIBUTE6
, CCAL.ATTRIBUTE7 ATTRIBUTE7
, CCAL.ATTRIBUTE8 ATTRIBUTE8
, CCAL.ATTRIBUTE9 ATTRIBUTE9
, CCAL.ATTRIBUTE10 ATTRIBUTE10
, CCAL.ATTRIBUTE11 ATTRIBUTE11
, CCAL.ATTRIBUTE12 ATTRIBUTE12
, CCAL.ATTRIBUTE13 ATTRIBUTE13
, CCAL.ATTRIBUTE14 ATTRIBUTE14
, CCAL.ATTRIBUTE15 ATTRIBUTE15
, CCAL.CREATED_BY CREATED_BY
, CCAL.CREATION_DATE CREATION_DATE
, CCAL.LAST_UPDATED_BY LAST_UPDATED_BY
, CCAL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCAL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCAL.CC_FUNC_WITHHELD_AMT CC_FUNC_WITHHELD_AMT
, CCAL.CC_ENT_WITHHELD_AMT CC_ENT_WITHHELD_AMT
, IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(CCAL.CC_HEADER_ID
, NVL(CCAL.CC_FUNC_WITHHELD_AMT
, 0)) CC_COMP_FUNC_WHLD_AMT
, CCAL.TAX_CLASSIF_CODE TAX_CLASSIF_CODE
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_ALL PPEV
, PA_TASKS PTEV
, HR_ALL_ORGANIZATION_UNITS_TL POEV
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 POEV.ORGANIZATION_ID (+) = CCAL.EXPENDITURE_ORG_ID
AND POEV.LANGUAGE (+) = USERENV('LANG')