VIEW: APPS.PSP_DEST_ACCT_LINES_V

Source

View Text - Preformatted

SELECT PTDS. ACCT_GROUP_ID, PTDS.DR_CR_FLAG, PTDS.GL_CODE_COMBINATION_ID, PTDS.PROJECT_ID, PTDS.EXPENDITURE_ORGANIZATION_ID, PTDS. EXPENDITURE_TYPE, PTDS.TASK_ID, PTDS. AWARD_ID, PTDS.DISTRIBUTION_SUM, PTDS. DISTRIBUTION_PERCENT, PTDS. ORIGINAL_LINE_FLAG, PTDS. RUN_ID, DECODE(ptds.project_id, NULL, NULL, psp_general.get_project_number(ptds.project_id)) project_number, DECODE(ptds.project_id, NULL, NULL, psp_general.get_task_number(ptds.task_id)) task_number, DECODE(ptds.award_id, NULL, NULL,psp_organization_accounts_pkg.return_default_award_id, psp_organization_accounts_pkg.return_default_award_number, psp_general.get_award_number(ptds.award_id)) award_number, DECODE(ptds.project_id, NULL, NULL, psp_general.get_org_name(ptds.expenditure_organization_id)) expenditure_organization_name, PTDS.BUSINESS_GROUP_ID, PTDS.SET_OF_BOOKS_ID, DECODE(ptds.element_type_id, NULL, NULL, psp_general.get_element_name(ptds.element_type_id)) ELEMENT_NAME, PTDS.ELEMENT_TYPE_ID, peg.element_group_name, PTDS.ELEMENT_GROUP_ID, PTDS.ADJ_SET_NUMBER, PTDS.LINE_NUMBER, PTDS.ADJSET_FREEZE_FLAG, PTDS.ATTRIBUTE_CATEGORY, PTDS.ATTRIBUTE1, PTDS.ATTRIBUTE2, PTDS.ATTRIBUTE3, PTDS.ATTRIBUTE4, PTDS.ATTRIBUTE5, PTDS.ATTRIBUTE6, PTDS.ATTRIBUTE7, PTDS.ATTRIBUTE8, PTDS.ATTRIBUTE9, PTDS.ATTRIBUTE10 FROM PSP_TEMP_DEST_SUMLINES PTDS, PSP_ELEMENT_GROUPS peg WHERE peg.element_group_id (+) = NVL(ptds.element_group_id, -99)

View Text - HTML Formatted

SELECT PTDS. ACCT_GROUP_ID
, PTDS.DR_CR_FLAG
, PTDS.GL_CODE_COMBINATION_ID
, PTDS.PROJECT_ID
, PTDS.EXPENDITURE_ORGANIZATION_ID
, PTDS. EXPENDITURE_TYPE
, PTDS.TASK_ID
, PTDS. AWARD_ID
, PTDS.DISTRIBUTION_SUM
, PTDS. DISTRIBUTION_PERCENT
, PTDS. ORIGINAL_LINE_FLAG
, PTDS. RUN_ID
, DECODE(PTDS.PROJECT_ID
, NULL
, NULL
, PSP_GENERAL.GET_PROJECT_NUMBER(PTDS.PROJECT_ID)) PROJECT_NUMBER
, DECODE(PTDS.PROJECT_ID
, NULL
, NULL
, PSP_GENERAL.GET_TASK_NUMBER(PTDS.TASK_ID)) TASK_NUMBER
, DECODE(PTDS.AWARD_ID
, NULL
, NULL
, PSP_ORGANIZATION_ACCOUNTS_PKG.RETURN_DEFAULT_AWARD_ID
, PSP_ORGANIZATION_ACCOUNTS_PKG.RETURN_DEFAULT_AWARD_NUMBER
, PSP_GENERAL.GET_AWARD_NUMBER(PTDS.AWARD_ID)) AWARD_NUMBER
, DECODE(PTDS.PROJECT_ID
, NULL
, NULL
, PSP_GENERAL.GET_ORG_NAME(PTDS.EXPENDITURE_ORGANIZATION_ID)) EXPENDITURE_ORGANIZATION_NAME
, PTDS.BUSINESS_GROUP_ID
, PTDS.SET_OF_BOOKS_ID
, DECODE(PTDS.ELEMENT_TYPE_ID
, NULL
, NULL
, PSP_GENERAL.GET_ELEMENT_NAME(PTDS.ELEMENT_TYPE_ID)) ELEMENT_NAME
, PTDS.ELEMENT_TYPE_ID
, PEG.ELEMENT_GROUP_NAME
, PTDS.ELEMENT_GROUP_ID
, PTDS.ADJ_SET_NUMBER
, PTDS.LINE_NUMBER
, PTDS.ADJSET_FREEZE_FLAG
, PTDS.ATTRIBUTE_CATEGORY
, PTDS.ATTRIBUTE1
, PTDS.ATTRIBUTE2
, PTDS.ATTRIBUTE3
, PTDS.ATTRIBUTE4
, PTDS.ATTRIBUTE5
, PTDS.ATTRIBUTE6
, PTDS.ATTRIBUTE7
, PTDS.ATTRIBUTE8
, PTDS.ATTRIBUTE9
, PTDS.ATTRIBUTE10
FROM PSP_TEMP_DEST_SUMLINES PTDS
, PSP_ELEMENT_GROUPS PEG
WHERE PEG.ELEMENT_GROUP_ID (+) = NVL(PTDS.ELEMENT_GROUP_ID
, -99)