View: IGCFV_CC_ACCOUNT_LINES

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGCFV_CC_ACCOUNT_LINES

View Text

SELECT IGCCAL.CC_ACCT_LINE_NUM ACCOUNT_LINE_NUMBER
, IGCCAL.CC_ACCT_ENTERED_AMT ACCOUNT_ENTERED_AMOUNT
, IGCCAL.CC_ACCT_FUNC_AMT ACCOUNT_FUNCTIONAL_AMOUNT
, IGCCAL.CC_ACCT_BILLED_AMT ACCOUNT_BILLED_AMOUNT
, IGCCAL.CC_ACCT_UNBILLED_AMT ACCOUNT_UNBILLED_AMOUNT
, IGCCAL.CC_ACCT_ENCMBRNC_AMT ACCOUNT_ENCUMBRANCE_AMOUNT
, IGCCAL.CC_ACCT_ENCMBRNC_DATE ACCOUNT_ENCUMBRANCE_DATE
, '_LA:CC_ACCT_TAXABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING' "_LA:ACCOUNT_TAXABLE_FLAG"
, '_LA:CC_ACCT_ENCMBRNC_STATUS:FND_LOOKUPS:IGC_CC_ENCUMBRANCE_STATUS:MEANING' "_LA:ACCT_ENCUMBRANCE_STATUS"
, IGCCAL.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, IGCCAL.CC_ACCT_DESC DESCRIPTION
, '_KF:SQLGL:GL#:GL_CODE_COMBINATIONS' "_KF:GL_ACCOUNT"
, '_DF:IGC:IGC_CC_ACCT_LINES:IGCCAL' "_DF"
, AP_TAX_CODES_ALL.NAME TAX_NAME
, PA_PROJECTS_ALL.NAME PROJECT_NAME
, PA_PROJECTS_ALL.SEGMENT1 PROJECT_NUMBER
, PA_TASKS.TASK_NUMBER TASK_NUMBER
, PA_TASKS.TASK_NAME TASK_NAME
, PA_ALL_ORGANIZATIONS.PA_ORG_USE_TYPE PROJECT_ORG_USE_TYPE
, PA_EXPENDITURE_TYPES.EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, IGC_CCH.CC_NUM CONTRACT_COMMIMTMENT_NUMBER
, IGCCAL.CC_HEADER_ID CONTRACT_COMMITMENT_ID
, IGCCAL.CC_CHARGE_CODE_COMBINATION_ID CHARGE_CODE_COMBINATION_ID
, IGCCAL.CC_BUDGET_CODE_COMBINATION_ID BUDGET_CODE_COMBINATION_ID
, IGCCAL.TAX_ID TAX_ID
, IGCCAL.PROJECT_ID PROJECT_ID
, IGCCAL.TASK_ID TASK_ID
, IGCCAL.EXPENDITURE_TYPE EXPENDITURE_TYPE
, IGCCAL.EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, IGCCAL.CC_ACCT_LINE_ID ACCOUNT_LINE_ID
, IGCCAL.LAST_UPDATED_BY LAST_UPDATED_BY
, IGCCAL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IGCCAL.CREATION_DATE CREATION_DATE
, IGCCAL.CREATED_BY CREATED_BY
FROM IGC_CC_ACCT_LINES IGCCAL
, IGC_CC_HEADERS IGC_CCH
, GL_CODE_COMBINATIONS GL_CODE_COMBINATIONS
, AP_TAX_CODES_ALL AP_TAX_CODES_ALL
, PA_ALL_ORGANIZATIONS PA_ALL_ORGANIZATIONS
, PA_EXPENDITURE_TYPES PA_EXPENDITURE_TYPES
, PA_PROJECTS_ALL PA_PROJECTS_ALL
, PA_TASKS PA_TASKS
WHERE IGCCAL.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID
AND IGCCAL.CC_CHARGE_CODE_COMBINATION_ID= GL_CODE_COMBINATIONS.CODE_COMBINATION_ID (+)
AND IGCCAL.CC_BUDGET_CODE_COMBINATION_ID= GL_CODE_COMBINATIONS.CODE_COMBINATION_ID (+)
AND IGCCAL.TAX_ID=AP_TAX_CODES_ALL.TAX_ID (+)
AND IGCCAL.PROJECT_ID=PA_PROJECTS_ALL.PROJECT_ID (+)
AND IGCCAL.TASK_ID=PA_TASKS.TASK_ID (+)
AND IGCCAL.EXPENDITURE_TYPE=PA_EXPENDITURE_TYPES. EXPENDITURE_TYPE (+)
AND IGCCAL.EXPENDITURE_ORG_ID=PA_ALL_ORGANIZATIONS. ORGANIZATION_ID (+)
AND '_SEC:IGCCAL.EXPENDITURE_ORG_ID' IS NOT NULL WITH READ ONLY

Columns