VIEW: PO.PO_REQ_DISTRIBUTIONS_ALL#

Source

View Text - Preformatted

select DISTRIBUTION_ID DISTRIBUTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUISITION_LINE_ID REQUISITION_LINE_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, REQ_LINE_QUANTITY REQ_LINE_QUANTITY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ENCUMBERED_FLAG ENCUMBERED_FLAG, GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE, GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME, GL_CANCELLED_DATE GL_CANCELLED_DATE, FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE, ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, EXPENDITURE_TYPE EXPENDITURE_TYPE, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, GL_CLOSED_DATE GL_CLOSED_DATE, SOURCE_REQ_DISTRIBUTION_ID SOURCE_REQ_DISTRIBUTION_ID, DISTRIBUTION_NUM DISTRIBUTION_NUM, ALLOCATION_TYPE ALLOCATION_TYPE, ALLOCATION_VALUE ALLOCATION_VALUE, PROJECT_RELATED_FLAG PROJECT_RELATED_FLAG, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, ORG_ID ORG_ID, AWARD_ID AWARD_ID, RECOVERABLE_TAX RECOVERABLE_TAX, NONRECOVERABLE_TAX NONRECOVERABLE_TAX, RECOVERY_RATE RECOVERY_RATE, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG, OKE_CONTRACT_LINE_ID OKE_CONTRACT_LINE_ID, OKE_CONTRACT_DELIVERABLE_ID OKE_CONTRACT_DELIVERABLE_ID, REQ_LINE_AMOUNT REQ_LINE_AMOUNT, REQ_LINE_CURRENCY_AMOUNT REQ_LINE_CURRENCY_AMOUNT, REQ_AWARD_ID REQ_AWARD_ID, EVENT_ID EVENT_ID, CONFORMED_DIST_ID CONFORMED_DIST_ID, AMENDMENT_TYPE AMENDMENT_TYPE, AMENDMENT_STATUS AMENDMENT_STATUS, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, INFO_LINE_ID INFO_LINE_ID, AMOUNT_FUNDED AMOUNT_FUNDED, FUNDED_VALUE FUNDED_VALUE, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG, QUANTITY_FUNDED QUANTITY_FUNDED, CLM_MISC_LOA CLM_MISC_LOA, CLM_DEFENCE_FUNDING CLM_DEFENCE_FUNDING, CLM_FMS_CASE_NUMBER CLM_FMS_CASE_NUMBER, CLM_AGENCY_ACCT_IDENTIFIER CLM_AGENCY_ACCT_IDENTIFIER, CHANGE_IN_FUNDED_VALUE CHANGE_IN_FUNDED_VALUE, UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT, FUNDS_LIQUIDATED FUNDS_LIQUIDATED, ACRN ACRN, PAR_DISTRIBUTION_ID PAR_DISTRIBUTION_ID, PAR_DRAFT_ID PAR_DRAFT_ID from "PO"."PO_REQ_DISTRIBUTIONS_ALL"

View Text - HTML Formatted

SELECT DISTRIBUTION_ID DISTRIBUTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, REQ_LINE_QUANTITY REQ_LINE_QUANTITY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ENCUMBERED_FLAG ENCUMBERED_FLAG
, GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE
, GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME
, GL_CANCELLED_DATE GL_CANCELLED_DATE
, FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE
, ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT
, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID
, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID
, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, GL_CLOSED_DATE GL_CLOSED_DATE
, SOURCE_REQ_DISTRIBUTION_ID SOURCE_REQ_DISTRIBUTION_ID
, DISTRIBUTION_NUM DISTRIBUTION_NUM
, ALLOCATION_TYPE ALLOCATION_TYPE
, ALLOCATION_VALUE ALLOCATION_VALUE
, PROJECT_RELATED_FLAG PROJECT_RELATED_FLAG
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, ORG_ID ORG_ID
, AWARD_ID AWARD_ID
, RECOVERABLE_TAX RECOVERABLE_TAX
, NONRECOVERABLE_TAX NONRECOVERABLE_TAX
, RECOVERY_RATE RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG
, OKE_CONTRACT_LINE_ID OKE_CONTRACT_LINE_ID
, OKE_CONTRACT_DELIVERABLE_ID OKE_CONTRACT_DELIVERABLE_ID
, REQ_LINE_AMOUNT REQ_LINE_AMOUNT
, REQ_LINE_CURRENCY_AMOUNT REQ_LINE_CURRENCY_AMOUNT
, REQ_AWARD_ID REQ_AWARD_ID
, EVENT_ID EVENT_ID
, CONFORMED_DIST_ID CONFORMED_DIST_ID
, AMENDMENT_TYPE AMENDMENT_TYPE
, AMENDMENT_STATUS AMENDMENT_STATUS
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, INFO_LINE_ID INFO_LINE_ID
, AMOUNT_FUNDED AMOUNT_FUNDED
, FUNDED_VALUE FUNDED_VALUE
, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG
, QUANTITY_FUNDED QUANTITY_FUNDED
, CLM_MISC_LOA CLM_MISC_LOA
, CLM_DEFENCE_FUNDING CLM_DEFENCE_FUNDING
, CLM_FMS_CASE_NUMBER CLM_FMS_CASE_NUMBER
, CLM_AGENCY_ACCT_IDENTIFIER CLM_AGENCY_ACCT_IDENTIFIER
, CHANGE_IN_FUNDED_VALUE CHANGE_IN_FUNDED_VALUE
, UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT
, FUNDS_LIQUIDATED FUNDS_LIQUIDATED
, ACRN ACRN
, PAR_DISTRIBUTION_ID PAR_DISTRIBUTION_ID
, PAR_DRAFT_ID PAR_DRAFT_ID
FROM "PO"."PO_REQ_DISTRIBUTIONS_ALL"