VIEW: APPS.IGCFV_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:CC_ACCT_ENCMBRNC_STATUS:FND_LOOKUPS:IGC_CC_ENCUMBRANCE_STATUS:MEANING' , IGCCAL.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, IGCCAL.CC_ACCT_DESC DESCRIPTION, '_KF:SQLGL:GL#:GL_CODE_COMBINATIONS' , '_DF:IGC:IGC_CC_ACCT_LINES:IGCCAL' , 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_ALL 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

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:CC_ACCT_ENCMBRNC_STATUS:FND_LOOKUPS:IGC_CC_ENCUMBRANCE_STATUS:MEANING'
, IGCCAL.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, IGCCAL.CC_ACCT_DESC DESCRIPTION
, '_KF:SQLGL:GL#:GL_CODE_COMBINATIONS'
, '_DF:IGC:IGC_CC_ACCT_LINES:IGCCAL'
, 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_ALL 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