VIEW: APPS.ICX_PO_REQ_DIST_V

Source

View Text - Preformatted

SELECT PRD.ROWID , PRL.REQUISITION_HEADER_ID , PRD.DISTRIBUTION_ID , PRD.LAST_UPDATE_DATE , PRD.LAST_UPDATED_BY , PRD.REQUISITION_LINE_ID , PRD.SET_OF_BOOKS_ID , PRD.CODE_COMBINATION_ID , PRD.REQ_LINE_QUANTITY , PRD.LAST_UPDATE_LOGIN , PRD.CREATION_DATE , PRD.CREATED_BY , PRD.ENCUMBERED_FLAG , PRD.GL_ENCUMBERED_DATE , PRD.GL_ENCUMBERED_PERIOD_NAME , PRD.GL_CANCELLED_DATE , PRD.FAILED_FUNDS_LOOKUP_CODE , PRD.ENCUMBERED_AMOUNT , PRD.BUDGET_ACCOUNT_ID , PRD.ACCRUAL_ACCOUNT_ID , PRD.VARIANCE_ACCOUNT_ID , PRD.PREVENT_ENCUMBRANCE_FLAG , PRD.ATTRIBUTE_CATEGORY , PRD.ATTRIBUTE1 , PRD.ATTRIBUTE2 , PRD.ATTRIBUTE3 , PRD.ATTRIBUTE4 , PRD.ATTRIBUTE5 , PRD.ATTRIBUTE6 , PRD.ATTRIBUTE7 , PRD.ATTRIBUTE8 , PRD.ATTRIBUTE9 , PRD.ATTRIBUTE10 , PRD.ATTRIBUTE11 , PRD.ATTRIBUTE12 , PRD.ATTRIBUTE13 , PRD.ATTRIBUTE14 , PRD.ATTRIBUTE15 , PRD.USSGL_TRANSACTION_CODE , PRD.GOVERNMENT_CONTEXT , PRD.REQUEST_ID , PRD.PROGRAM_APPLICATION_ID , PRD.PROGRAM_ID , PRD.PROGRAM_UPDATE_DATE , PRD.PROJECT_ID , PRD.TASK_ID , PRD.EXPENDITURE_TYPE , PRD.PROJECT_ACCOUNTING_CONTEXT , PRD.EXPENDITURE_ORGANIZATION_ID , PRD.GL_CLOSED_DATE , PRD.SOURCE_REQ_DISTRIBUTION_ID , PRD.DISTRIBUTION_NUM , PRD.PROJECT_RELATED_FLAG , PRD.EXPENDITURE_ITEM_DATE , PRD.ORG_ID , PRD.ALLOCATION_TYPE , PRD.ALLOCATION_VALUE , PP.SEGMENT1 , PT.TASK_NUMBER , ICX_GET.GET_GL_ACCOUNT(PRD.CODE_COMBINATION_ID) , ICX_GET.GET_GL_ACCOUNT(PRD.BUDGET_ACCOUNT_ID) , ICX_GET.GET_GL_ACCOUNT(PRD.ACCRUAL_ACCOUNT_ID) , ICX_GET.GET_GL_ACCOUNT(PRD.VARIANCE_ACCOUNT_ID) , POU.NAME , ICX_GET.GET_GL_VALUE(101,'GL#',101,PRD.CODE_COMBINATION_ID, 'COST CENTER') , ICX_GET.GET_GL_VALUE(101,'GL#',101,PRD.CODE_COMBINATION_ID, 'ACCOUNT') , ICX_GET.GET_GL_VALUE(101,'GL#',101,PRD.CODE_COMBINATION_ID, 'COMPANY') FROM PO_REQ_DISTRIBUTIONS PRD , PO_REQUISITION_LINES PRL , PA_PROJECTS PP , PA_TASKS PT , PER_ORGANIZATION_UNITS POU WHERE PRL.REQUISITION_LINE_ID > 0 AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID AND PRD.PROJECT_ID = PP.PROJECT_ID(+) AND PRD.TASK_ID = PT.TASK_ID(+) AND PRD.EXPENDITURE_ORGANIZATION_ID = POU.ORGANIZATION_ID(+)

View Text - HTML Formatted

SELECT PRD.ROWID
, PRL.REQUISITION_HEADER_ID
, PRD.DISTRIBUTION_ID
, PRD.LAST_UPDATE_DATE
, PRD.LAST_UPDATED_BY
, PRD.REQUISITION_LINE_ID
, PRD.SET_OF_BOOKS_ID
, PRD.CODE_COMBINATION_ID
, PRD.REQ_LINE_QUANTITY
, PRD.LAST_UPDATE_LOGIN
, PRD.CREATION_DATE
, PRD.CREATED_BY
, PRD.ENCUMBERED_FLAG
, PRD.GL_ENCUMBERED_DATE
, PRD.GL_ENCUMBERED_PERIOD_NAME
, PRD.GL_CANCELLED_DATE
, PRD.FAILED_FUNDS_LOOKUP_CODE
, PRD.ENCUMBERED_AMOUNT
, PRD.BUDGET_ACCOUNT_ID
, PRD.ACCRUAL_ACCOUNT_ID
, PRD.VARIANCE_ACCOUNT_ID
, PRD.PREVENT_ENCUMBRANCE_FLAG
, PRD.ATTRIBUTE_CATEGORY
, PRD.ATTRIBUTE1
, PRD.ATTRIBUTE2
, PRD.ATTRIBUTE3
, PRD.ATTRIBUTE4
, PRD.ATTRIBUTE5
, PRD.ATTRIBUTE6
, PRD.ATTRIBUTE7
, PRD.ATTRIBUTE8
, PRD.ATTRIBUTE9
, PRD.ATTRIBUTE10
, PRD.ATTRIBUTE11
, PRD.ATTRIBUTE12
, PRD.ATTRIBUTE13
, PRD.ATTRIBUTE14
, PRD.ATTRIBUTE15
, PRD.USSGL_TRANSACTION_CODE
, PRD.GOVERNMENT_CONTEXT
, PRD.REQUEST_ID
, PRD.PROGRAM_APPLICATION_ID
, PRD.PROGRAM_ID
, PRD.PROGRAM_UPDATE_DATE
, PRD.PROJECT_ID
, PRD.TASK_ID
, PRD.EXPENDITURE_TYPE
, PRD.PROJECT_ACCOUNTING_CONTEXT
, PRD.EXPENDITURE_ORGANIZATION_ID
, PRD.GL_CLOSED_DATE
, PRD.SOURCE_REQ_DISTRIBUTION_ID
, PRD.DISTRIBUTION_NUM
, PRD.PROJECT_RELATED_FLAG
, PRD.EXPENDITURE_ITEM_DATE
, PRD.ORG_ID
, PRD.ALLOCATION_TYPE
, PRD.ALLOCATION_VALUE
, PP.SEGMENT1
, PT.TASK_NUMBER
, ICX_GET.GET_GL_ACCOUNT(PRD.CODE_COMBINATION_ID)
, ICX_GET.GET_GL_ACCOUNT(PRD.BUDGET_ACCOUNT_ID)
, ICX_GET.GET_GL_ACCOUNT(PRD.ACCRUAL_ACCOUNT_ID)
, ICX_GET.GET_GL_ACCOUNT(PRD.VARIANCE_ACCOUNT_ID)
, POU.NAME
, ICX_GET.GET_GL_VALUE(101
, 'GL#'
, 101
, PRD.CODE_COMBINATION_ID
, 'COST CENTER')
, ICX_GET.GET_GL_VALUE(101
, 'GL#'
, 101
, PRD.CODE_COMBINATION_ID
, 'ACCOUNT')
, ICX_GET.GET_GL_VALUE(101
, 'GL#'
, 101
, PRD.CODE_COMBINATION_ID
, 'COMPANY')
FROM PO_REQ_DISTRIBUTIONS PRD
, PO_REQUISITION_LINES PRL
, PA_PROJECTS PP
, PA_TASKS PT
, PER_ORGANIZATION_UNITS POU
WHERE PRL.REQUISITION_LINE_ID > 0
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRD.PROJECT_ID = PP.PROJECT_ID(+)
AND PRD.TASK_ID = PT.TASK_ID(+)
AND PRD.EXPENDITURE_ORGANIZATION_ID = POU.ORGANIZATION_ID(+)