VIEW: APPS.PSP_DISTRIBUTION_INTERFACE_V

Source

View Text - Preformatted

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_ORGANIZATION_ACCOUNTS_PKG.RETURN_DEFAULT_AWARD_ID, PSP_ORGANIZATION_ACCOUNTS_PKG.RETURN_DEFAULT_AWARD_NUMBER, 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

View Text - HTML Formatted

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_ORGANIZATION_ACCOUNTS_PKG.RETURN_DEFAULT_AWARD_ID
, PSP_ORGANIZATION_ACCOUNTS_PKG.RETURN_DEFAULT_AWARD_NUMBER
, 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