VIEW: APPS.IGCFV_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:IGCCAL.CC_ACCT_TAXABLE_FLAG:FND_LOOKUPS:YES_NO: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' , 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_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,IGC_CC_ACCT_LINES IGCCALP,IGC_CC_HEADERS_ALL 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

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:IGCCAL.CC_ACCT_TAXABLE_FLAG:FND_LOOKUPS:YES_NO: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'
, 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_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
, IGC_CC_ACCT_LINES IGCCALP
, IGC_CC_HEADERS_ALL 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