VIEW: APPS.IGCBV_CC_ACCOUNT_LINES

Source

View Text - Preformatted

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, 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 WHERE '_SEC:IGCCAL.EXPENDITURE_ORG_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

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
, 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
WHERE '_SEC:IGCCAL.EXPENDITURE_ORG_ID' IS NOT NULL WITH READ ONLY