View: IGCFV_CC_RELEASE_ACCOUNT_LINES

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

View Text

SELECT IGCCAL.CC_ACCT_LINE_NUM RELEASE_ACCOUNT_LINE_NUMBER
, IGCCAL.CC_ACCT_ENTERED_AMT RELEASE_ACCOUNT_ENTERED_AMOUNT
, IGCCAL.CC_ACCT_FUNC_AMT RELEASE_ACCT_FUNCTIONAL_AMOUNT
, IGCCAL.CC_ACCT_BILLED_AMT RELEASE_ACCOUNT_BILLED_AMOUNT
, IGCCAL.CC_ACCT_UNBILLED_AMT RELEASE_ACCT_UNBILLED_AMOUNT
, '_LA:IGCCAL.CC_ACCT_TAXABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING' "_LA:ACCOUNT_TAXABLE_FLAG"
, 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"
, IGC_CCH.CC_NUM RELEASE_CONTRACT_NUMBER
, IGC_CCHP.CC_NUM PARENT_CONTRACT_NUMBER
, IGCCALP.CC_ACCT_LINE_NUM PARENT_ACCOUNT_LINE_NUMBER
, 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
, 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.PARENT_HEADER_ID PARENT_CONTRACT_COMMITMENT_ID
, IGCCAL.PARENT_ACCT_LINE_ID PARENT_ACCOUNT_LINE_ID
, IGCCAL.CC_HEADER_ID RELEASE_CONTRACT_COMMITMENT_ID
, IGCCAL.CC_ACCT_LINE_ID RELEASE_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
, IGC_CC_ACCT_LINES IGCCALP
, IGC_CC_HEADERS IGC_CCHP
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 IGCCAL.PARENT_ACCT_LINE_ID=IGCCALP.CC_ACCT_LINE_ID
AND IGC_CCH.PARENT_HEADER_ID=IGC_CCHP.CC_HEADER_ID
AND IGC_CCH.CC_TYPE = 'R'
AND '_SEC:IGCCAL.EXPENDITURE_ORG_ID' IS NOT NULL WITH READ ONLY

Columns