VIEW: APPS.POR_DISTRIBUTIONS_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, 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

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
, 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