Product: | ICX - Oracle iProcurement |
---|---|
Description: | Distribution View |
Implementation/DBA Data: | APPS.POR_DISTRIBUTIONS_V |
SELECT DIST.DISTRIBUTION_ID
, DIST.REQUISITION_LINE_ID
, DIST.CODE_COMBINATION_ID
, DIST.REQ_LINE_QUANTITY
, DIST.ENCUMBERED_FLAG
, DIST.GL_ENCUMBERED_DATE
, DIST.GL_ENCUMBERED_PERIOD_NAME
, DIST.GL_CANCELLED_DATE
, DIST.FAILED_FUNDS_LOOKUP_CODE
, DIST.ENCUMBERED_AMOUNT
, DIST.BUDGET_ACCOUNT_ID
, DIST.ACCRUAL_ACCOUNT_ID
, DIST.ORG_ID
, DIST.VARIANCE_ACCOUNT_ID
, DIST.PREVENT_ENCUMBRANCE_FLAG
, DIST.USSGL_TRANSACTION_CODE
, DIST.PROJECT_ID
, DIST.TASK_ID
, DIST.EXPENDITURE_TYPE
, DIST.PROJECT_ACCOUNTING_CONTEXT
, DIST.EXPENDITURE_ORGANIZATION_ID
, DIST.GL_CLOSED_DATE
, DIST.SOURCE_REQ_DISTRIBUTION_ID
, DIST.DISTRIBUTION_NUM
, DIST.PROJECT_RELATED_FLAG
, DIST.EXPENDITURE_ITEM_DATE
, DIST.SET_OF_BOOKS_ID
, NVL(DIST.ALLOCATION_TYPE
, 'QUANTITY') "ALLOCATION_TYPE"
, NVL(DIST.ALLOCATION_VALUE
, REQ_LINE_QUANTITY) "ALLOCATION_VALUE"
, (REQ_LINE_QUANTITY/LINE.QUANTITY*100) "PERCENTAGE"
, REQ_LINE_QUANTITY "QUANTITY"
, REQ_LINE_QUANTITY*LINE.UNIT_PRICE "AMOUNT"
, DIST.ATTRIBUTE1
, DIST.ATTRIBUTE2
, DIST.ATTRIBUTE3
, DIST.ATTRIBUTE4
, DIST.ATTRIBUTE5
, DIST.ATTRIBUTE6
, DIST.ATTRIBUTE7
, DIST.ATTRIBUTE8
, DIST.ATTRIBUTE9
, DIST.ATTRIBUTE10
, DIST.ATTRIBUTE11
, DIST.ATTRIBUTE12
, DIST.ATTRIBUTE13
, DIST.ATTRIBUTE14
, DIST.ATTRIBUTE15
, DIST.RECOVERABLE_TAX
, DIST.NONRECOVERABLE_TAX
, DIST.RECOVERY_RATE
, DIST.TAX_RECOVERY_OVERRIDE_FLAG
FROM PO_REQ_DISTRIBUTIONS DIST
, PO_REQUISITION_LINES LINE
WHERE DIST.REQUISITION_LINE_ID= LINE.REQUISITION_LINE_ID