VIEW: APPS.PO_REQ_DISTRIBUTIONS_V

Source

View Text - Preformatted

SELECT ROWID , DISTRIBUTION_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , REQUISITION_LINE_ID , SET_OF_BOOKS_ID , CODE_COMBINATION_ID , REQ_LINE_QUANTITY , LAST_UPDATE_LOGIN , CREATION_DATE , CREATED_BY , NVL(ENCUMBERED_FLAG,'N') , GL_ENCUMBERED_DATE , GL_ENCUMBERED_PERIOD_NAME , GL_CANCELLED_DATE , FAILED_FUNDS_LOOKUP_CODE , ENCUMBERED_AMOUNT , BUDGET_ACCOUNT_ID , ACCRUAL_ACCOUNT_ID , VARIANCE_ACCOUNT_ID , PREVENT_ENCUMBRANCE_FLAG , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , USSGL_TRANSACTION_CODE , GOVERNMENT_CONTEXT , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , TASK_ID , EXPENDITURE_TYPE , PROJECT_ACCOUNTING_CONTEXT , EXPENDITURE_ORGANIZATION_ID , GL_CLOSED_DATE , SOURCE_REQ_DISTRIBUTION_ID , DISTRIBUTION_NUM , PROJECT_RELATED_FLAG , EXPENDITURE_ITEM_DATE , END_ITEM_UNIT_NUMBER , RECOVERABLE_TAX , NONRECOVERABLE_TAX , RECOVERY_RATE , TAX_RECOVERY_OVERRIDE_FLAG , AWARD_ID , OKE_CONTRACT_LINE_ID , OKE_CONTRACT_DELIVERABLE_ID , REQ_LINE_AMOUNT , REQ_LINE_CURRENCY_AMOUNT , ORG_ID FROM PO_REQ_DISTRIBUTIONS

View Text - HTML Formatted

SELECT ROWID
, DISTRIBUTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUISITION_LINE_ID
, SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, REQ_LINE_QUANTITY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, NVL(ENCUMBERED_FLAG
, 'N')
, GL_ENCUMBERED_DATE
, GL_ENCUMBERED_PERIOD_NAME
, GL_CANCELLED_DATE
, FAILED_FUNDS_LOOKUP_CODE
, ENCUMBERED_AMOUNT
, BUDGET_ACCOUNT_ID
, ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID
, PREVENT_ENCUMBRANCE_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, TASK_ID
, EXPENDITURE_TYPE
, PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION_ID
, GL_CLOSED_DATE
, SOURCE_REQ_DISTRIBUTION_ID
, DISTRIBUTION_NUM
, PROJECT_RELATED_FLAG
, EXPENDITURE_ITEM_DATE
, END_ITEM_UNIT_NUMBER
, RECOVERABLE_TAX
, NONRECOVERABLE_TAX
, RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG
, AWARD_ID
, OKE_CONTRACT_LINE_ID
, OKE_CONTRACT_DELIVERABLE_ID
, REQ_LINE_AMOUNT
, REQ_LINE_CURRENCY_AMOUNT
, ORG_ID
FROM PO_REQ_DISTRIBUTIONS