VIEW: APPS.PSP_ORIG_ACCT_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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