DBA Data[Home] [Help]

VIEW: PO.PO_DISTRIBUTIONS_ARCHIVE_ALL#

Source

View Text - Preformatted

select PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, LINE_LOCATION_ID LINE_LOCATION_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, QUANTITY_ORDERED QUANTITY_ORDERED, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PO_RELEASE_ID PO_RELEASE_ID, QUANTITY_DELIVERED QUANTITY_DELIVERED, QUANTITY_BILLED QUANTITY_BILLED, QUANTITY_CANCELLED QUANTITY_CANCELLED, REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM, REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID, RATE_DATE RATE_DATE, RATE RATE, AMOUNT_BILLED AMOUNT_BILLED, ACCRUED_FLAG ACCRUED_FLAG, ENCUMBERED_FLAG ENCUMBERED_FLAG, ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT, UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY, UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT, FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE, GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE, GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME, GL_CANCELLED_DATE GL_CANCELLED_DATE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, 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, WIP_ENTITY_ID WIP_ENTITY_ID, WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM, WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID, WIP_LINE_ID WIP_LINE_ID, BOM_RESOURCE_ID BOM_RESOURCE_ID, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID, DESTINATION_CONTEXT DESTINATION_CONTEXT, DISTRIBUTION_NUM DISTRIBUTION_NUM, SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID, REVISION_NUM REVISION_NUM, LATEST_EXTERNAL_FLAG LATEST_EXTERNAL_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, 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, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, GL_CLOSED_DATE GL_CLOSED_DATE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, ORG_ID ORG_ID, KANBAN_CARD_ID KANBAN_CARD_ID, AWARD_ID AWARD_ID, MRC_RATE_DATE MRC_RATE_DATE, MRC_RATE MRC_RATE, MRC_ENCUMBERED_AMOUNT MRC_ENCUMBERED_AMOUNT, MRC_UNENCUMBERED_AMOUNT MRC_UNENCUMBERED_AMOUNT, 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, AMOUNT_ORDERED AMOUNT_ORDERED, AMOUNT_DELIVERED AMOUNT_DELIVERED, AMOUNT_CANCELLED AMOUNT_CANCELLED, DISTRIBUTION_TYPE DISTRIBUTION_TYPE, AMOUNT_TO_ENCUMBER AMOUNT_TO_ENCUMBER, INVOICE_ADJUSTMENT_FLAG INVOICE_ADJUSTMENT_FLAG, DEST_CHARGE_ACCOUNT_ID DEST_CHARGE_ACCOUNT_ID, DEST_VARIANCE_ACCOUNT_ID DEST_VARIANCE_ACCOUNT_ID, QUANTITY_FINANCED QUANTITY_FINANCED, AMOUNT_FINANCED AMOUNT_FINANCED, QUANTITY_RECOUPED QUANTITY_RECOUPED, AMOUNT_RECOUPED AMOUNT_RECOUPED, RETAINAGE_WITHHELD_AMOUNT RETAINAGE_WITHHELD_AMOUNT, RETAINAGE_RELEASED_AMOUNT RETAINAGE_RELEASED_AMOUNT, GROUP_LINE_ID GROUP_LINE_ID, AMOUNT_FUNDED AMOUNT_FUNDED, FUNDED_VALUE FUNDED_VALUE, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG, QUANTITY_FUNDED QUANTITY_FUNDED, CHANGE_IN_FUNDED_VALUE CHANGE_IN_FUNDED_VALUE, CLM_AGENCY_ACCT_IDENTIFIER CLM_AGENCY_ACCT_IDENTIFIER, CLM_DEFENCE_FUNDING CLM_DEFENCE_FUNDING, CLM_FMS_CASE_NUMBER CLM_FMS_CASE_NUMBER, CLM_MISC_LOA CLM_MISC_LOA, INTERFACE_DISTRIBUTION_REF INTERFACE_DISTRIBUTION_REF, INVOICED_VAL_IN_NTFN INVOICED_VAL_IN_NTFN, LCM_FLAG LCM_FLAG, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, WF_ITEM_KEY WF_ITEM_KEY, ACRN ACRN, CLM_PAYMENT_SEQUENCE_NUM CLM_PAYMENT_SEQUENCE_NUM from "PO"."PO_DISTRIBUTIONS_ARCHIVE_ALL"
View Text - HTML Formatted

SELECT PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, QUANTITY_ORDERED QUANTITY_ORDERED
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PO_RELEASE_ID PO_RELEASE_ID
, QUANTITY_DELIVERED QUANTITY_DELIVERED
, QUANTITY_BILLED QUANTITY_BILLED
, QUANTITY_CANCELLED QUANTITY_CANCELLED
, REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM
, REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM
, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, RATE_DATE RATE_DATE
, RATE RATE
, AMOUNT_BILLED AMOUNT_BILLED
, ACCRUED_FLAG ACCRUED_FLAG
, ENCUMBERED_FLAG ENCUMBERED_FLAG
, ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT
, UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY
, UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT
, FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE
, GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE
, GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME
, GL_CANCELLED_DATE GL_CANCELLED_DATE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, 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
, WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM
, WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID
, WIP_LINE_ID WIP_LINE_ID
, BOM_RESOURCE_ID BOM_RESOURCE_ID
, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID
, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID
, DESTINATION_CONTEXT DESTINATION_CONTEXT
, DISTRIBUTION_NUM DISTRIBUTION_NUM
, SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID
, REVISION_NUM REVISION_NUM
, LATEST_EXTERNAL_FLAG LATEST_EXTERNAL_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, 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
, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG
, GL_CLOSED_DATE GL_CLOSED_DATE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, ORG_ID ORG_ID
, KANBAN_CARD_ID KANBAN_CARD_ID
, AWARD_ID AWARD_ID
, MRC_RATE_DATE MRC_RATE_DATE
, MRC_RATE MRC_RATE
, MRC_ENCUMBERED_AMOUNT MRC_ENCUMBERED_AMOUNT
, MRC_UNENCUMBERED_AMOUNT MRC_UNENCUMBERED_AMOUNT
, 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
, AMOUNT_ORDERED AMOUNT_ORDERED
, AMOUNT_DELIVERED AMOUNT_DELIVERED
, AMOUNT_CANCELLED AMOUNT_CANCELLED
, DISTRIBUTION_TYPE DISTRIBUTION_TYPE
, AMOUNT_TO_ENCUMBER AMOUNT_TO_ENCUMBER
, INVOICE_ADJUSTMENT_FLAG INVOICE_ADJUSTMENT_FLAG
, DEST_CHARGE_ACCOUNT_ID DEST_CHARGE_ACCOUNT_ID
, DEST_VARIANCE_ACCOUNT_ID DEST_VARIANCE_ACCOUNT_ID
, QUANTITY_FINANCED QUANTITY_FINANCED
, AMOUNT_FINANCED AMOUNT_FINANCED
, QUANTITY_RECOUPED QUANTITY_RECOUPED
, AMOUNT_RECOUPED AMOUNT_RECOUPED
, RETAINAGE_WITHHELD_AMOUNT RETAINAGE_WITHHELD_AMOUNT
, RETAINAGE_RELEASED_AMOUNT RETAINAGE_RELEASED_AMOUNT
, GROUP_LINE_ID GROUP_LINE_ID
, AMOUNT_FUNDED AMOUNT_FUNDED
, FUNDED_VALUE FUNDED_VALUE
, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG
, QUANTITY_FUNDED QUANTITY_FUNDED
, CHANGE_IN_FUNDED_VALUE CHANGE_IN_FUNDED_VALUE
, CLM_AGENCY_ACCT_IDENTIFIER CLM_AGENCY_ACCT_IDENTIFIER
, CLM_DEFENCE_FUNDING CLM_DEFENCE_FUNDING
, CLM_FMS_CASE_NUMBER CLM_FMS_CASE_NUMBER
, CLM_MISC_LOA CLM_MISC_LOA
, INTERFACE_DISTRIBUTION_REF INTERFACE_DISTRIBUTION_REF
, INVOICED_VAL_IN_NTFN INVOICED_VAL_IN_NTFN
, LCM_FLAG LCM_FLAG
, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, WF_ITEM_KEY WF_ITEM_KEY
, ACRN ACRN
, CLM_PAYMENT_SEQUENCE_NUM CLM_PAYMENT_SEQUENCE_NUM
FROM "PO"."PO_DISTRIBUTIONS_ARCHIVE_ALL"