VIEW: APPS.POR_DISTRIBUTIONS_ALL_V

Source

View Text - Preformatted

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 FROM PO_REQ_DISTRIBUTIONS_ALL DIST, PO_REQUISITION_LINES_ALL LINE WHERE DIST.REQUISITION_LINE_ID= LINE.REQUISITION_LINE_ID

View Text - HTML Formatted

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
FROM PO_REQ_DISTRIBUTIONS_ALL DIST
, PO_REQUISITION_LINES_ALL LINE
WHERE DIST.REQUISITION_LINE_ID= LINE.REQUISITION_LINE_ID