Product: | PSP - Labor Distribution |
---|---|
Description: | Based on PSP_DISTRIBUTION_INTERFACE table |
Implementation/DBA Data: | APPS.PSP_DISTRIBUTION_INTERFACE_V |
SELECT A.PAYROLL_ID
, A.DISTRIBUTION_INTERFACE_ID
, PSP_GENERAL.GET_PAYROLL_NAME(A.PAYROLL_ID
, A.DISTRIBUTION_DATE) PAYROLL_NAME
, A.TIME_PERIOD_ID
, PSP_GENERAL.GET_PERIOD_NAME(A.TIME_PERIOD_ID) PERIOD_NAME
, A.PERSON_ID
, PSP_GENERAL.GET_PERSON_NAME(A.PERSON_ID
, A.DISTRIBUTION_DATE) PERSON
, A.ASSIGNMENT_ID
, PSP_GENERAL.GET_ASSIGNMENT_NUM(A.ASSIGNMENT_ID
, A.DISTRIBUTION_DATE) ASSIGNMENT_NUMBER
, A.ELEMENT_TYPE_ID
, PSP_GENERAL.GET_ELEMENT_NAME(A.ELEMENT_TYPE_ID
, A.DISTRIBUTION_DATE) ELEMENT_NAME
, A.DISTRIBUTION_AMOUNT
, A.DISTRIBUTION_DATE
, A.GL_CODE_COMBINATION_ID
, A.PROJECT_ID
, DECODE(A.PROJECT_ID
, NULL
, NULL
, PSP_GENERAL.GET_PROJECT_NUMBER(A.PROJECT_ID)) PROJECT_NAME
, A.SOURCE_CODE
, PSP_GENERAL.GET_SOURCE_TYPE('P'
, A.SOURCE_CODE) SOURCE_TYPE
, A.EXPENDITURE_ORGANIZATION_ID
, DECODE( A.EXPENDITURE_ORGANIZATION_ID
, NULL
, NULL
, PSP_GENERAL.GET_ORG_NAME(A.EXPENDITURE_ORGANIZATION_ID)) EXPENDITURE_ORGANIZATION_NAME
, A.EXPENDITURE_TYPE
, A.TASK_ID
, DECODE(A.TASK_ID
, NULL
, NULL
, PSP_GENERAL.GET_TASK_NUMBER(A.TASK_ID)) TASK_NAME
, A.AWARD_ID
, DECODE( A.AWARD_ID
, NULL
, NULL
, PSP_GENERAL.GET_AWARD_NUMBER(A.AWARD_ID)) AWARD_NAME
, A.STATUS_CODE
, PSP_GENERAL.GET_STATUS_DESCRIPTION(A.STATUS_CODE) STATUS_DESCRIPTION
, A.BATCH_NAME
, A.ERROR_CODE
, DECODE(A.STATUS_CODE
, 'E'
, PSP_GENERAL.GET_ERROR_DESCRIPTION(A.ERROR_CODE)
, NULL) ERROR_DESCRIPTION
, A.DR_CR_FLAG
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.BUSINESS_GROUP_ID
, A.GL_POSTING_OVERRIDE_DATE
, A.SET_OF_BOOKS_ID
, A.GMS_POSTING_OVERRIDE_DATE
FROM PSP_DISTRIBUTION_INTERFACE A