View: PSP_DEST_ACCT_LINES_V

Product:	PSP - Labor Distribution
Description:	Contains distribution lines and charging instructions for lines selected for adjustment
Implementation/DBA Data:	APPS.PSP_DEST_ACCT_LINES_V

View Text

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_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
, TRUNC(SYSDATE))) 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)

Columns