View: ICX_PO_REQ_DIST_V

Product:	ICX - Oracle iProcurement
Description:	Requisition Distribution Detail View
Implementation/DBA Data:	APPS.ICX_PO_REQ_DIST_V

View Text

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(+)

Columns