FND Design Data [Home] [Help]

View: IGCBV_CC_RELEASE_ACCOUNT_LINES

Product: IGC - Contract Commitment
Description:
Implementation/DBA Data: ViewAPPS.IGCBV_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:CC_ACCT_TAXABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING' "_LA:ACCOUNT_TAXABLE_FLAG"
, IGCCAL.CC_ACCT_DESC DESCRIPTION
, IGCCAL.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, IGCCAL.EXPENDITURE_TYPE EXPENDITURE_TYPE
, IGCCAL.EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, IGCCAL.CC_CHARGE_CODE_COMBINATION_ID CHARGE_CODE_COMBINATION
, IGCCAL.CC_BUDGET_CODE_COMBINATION_ID BUDGET_CODE_COMBINATION
, IGCCAL.TAX_ID TAX_ID
, IGCCAL.PROJECT_ID PROJECT_ID
, IGCCAL.TASK_ID TASK_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_UPDATE_DATE LAST_UPDATE_DATE
, IGCCAL.LAST_UPDATED_BY LAST_UPDATED_BY
, IGCCAL.CREATION_DATE CREATION_DATE
, IGCCAL.CREATED_BY CREATED_BY
FROM IGC_CC_ACCT_LINES IGCCAL
WHERE '_SEC:IGCCAL.EXPENDITURE_ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
RELEASE_ACCOUNT_LINE_NUMBER
RELEASE_ACCOUNT_ENTERED_AMOUNT
RELEASE_ACCT_FUNCTIONAL_AMOUNT
RELEASE_ACCOUNT_BILLED_AMOUNT
RELEASE_ACCT_UNBILLED_AMOUNT
"_LA:ACCOUNT_TAXABLE_FLAG"
DESCRIPTION
EXPENDITURE_ITEM_DATE
EXPENDITURE_TYPE
EXPENDITURE_ORG_ID
CHARGE_CODE_COMBINATION
BUDGET_CODE_COMBINATION
TAX_ID
PROJECT_ID
TASK_ID
PARENT_CONTRACT_COMMITMENT_ID
PARENT_ACCOUNT_LINE_ID
RELEASE_CONTRACT_COMMITMENT_ID
RELEASE_ACCOUNT_LINE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY