Product: | PSP - Labor Distribution |
---|---|
Description: | Based on PSP_TEMP_ORIG_SUMLINES |
Implementation/DBA Data: | APPS.PSP_ORIG_ACCT_LINES_V |
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
, TRUNC(SYSDATE))) 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)