VIEW: APPS.IGCBV_CC_RELEASE_ACCOUNT_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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