VIEW: PO.PO_DISTRIBUTIONS_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_HEADER_ID INTERFACE_HEADER_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, INTERFACE_DISTRIBUTION_ID INTERFACE_DISTRIBUTION_ID, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_ID PO_LINE_ID, LINE_LOCATION_ID LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, DISTRIBUTION_NUM DISTRIBUTION_NUM, SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID, ORG_ID ORG_ID, QUANTITY_ORDERED QUANTITY_ORDERED, QUANTITY_DELIVERED QUANTITY_DELIVERED, QUANTITY_BILLED QUANTITY_BILLED, QUANTITY_CANCELLED QUANTITY_CANCELLED, RATE_DATE RATE_DATE, RATE RATE, DELIVER_TO_LOCATION DELIVER_TO_LOCATION, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_PERSON_FULL_NAME DELIVER_TO_PERSON_FULL_NAME, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID, DESTINATION_TYPE DESTINATION_TYPE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION DESTINATION_ORGANIZATION, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, DESTINATION_CONTEXT DESTINATION_CONTEXT, SET_OF_BOOKS SET_OF_BOOKS, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CHARGE_ACCOUNT CHARGE_ACCOUNT, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, BUDGET_ACCOUNT BUDGET_ACCOUNT, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID, ACCURAL_ACCOUNT ACCURAL_ACCOUNT, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT VARIANCE_ACCOUNT, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID, AMOUNT_BILLED AMOUNT_BILLED, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, ACCRUED_FLAG ACCRUED_FLAG, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, ENCUMBERED_FLAG ENCUMBERED_FLAG, ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT, UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY, UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT, FAILED_FUNDS FAILED_FUNDS, 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, GL_CLOSED_DATE GL_CLOSED_DATE, REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM, REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, WIP_ENTITY WIP_ENTITY, 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 WIP_REPETITIVE_SCHEDULE, WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID, WIP_LINE_CODE WIP_LINE_CODE, WIP_LINE_ID WIP_LINE_ID, BOM_RESOURCE_CODE BOM_RESOURCE_CODE, BOM_RESOURCE_ID BOM_RESOURCE_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, PROJECT PROJECT, PROJECT_ID PROJECT_ID, TASK#2 TASK, TASK_ID TASK_ID, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, EXPENDITURE EXPENDITURE, EXPENDITURE_TYPE EXPENDITURE_TYPE, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, EXPENDITURE_ORGANIZATION EXPENDITURE_ORGANIZATION, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PROJECT_RELEATED_FLAG PROJECT_RELEATED_FLAG, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, 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, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RECOVERABLE_TAX RECOVERABLE_TAX, NONRECOVERABLE_TAX NONRECOVERABLE_TAX, RECOVERY_RATE RECOVERY_RATE, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG, AWARD_ID AWARD_ID, CHARGE_ACCOUNT_SEGMENT1 CHARGE_ACCOUNT_SEGMENT1, CHARGE_ACCOUNT_SEGMENT2 CHARGE_ACCOUNT_SEGMENT2, CHARGE_ACCOUNT_SEGMENT3 CHARGE_ACCOUNT_SEGMENT3, CHARGE_ACCOUNT_SEGMENT4 CHARGE_ACCOUNT_SEGMENT4, CHARGE_ACCOUNT_SEGMENT5 CHARGE_ACCOUNT_SEGMENT5, CHARGE_ACCOUNT_SEGMENT6 CHARGE_ACCOUNT_SEGMENT6, CHARGE_ACCOUNT_SEGMENT7 CHARGE_ACCOUNT_SEGMENT7, CHARGE_ACCOUNT_SEGMENT8 CHARGE_ACCOUNT_SEGMENT8, CHARGE_ACCOUNT_SEGMENT9 CHARGE_ACCOUNT_SEGMENT9, CHARGE_ACCOUNT_SEGMENT10 CHARGE_ACCOUNT_SEGMENT10, CHARGE_ACCOUNT_SEGMENT11 CHARGE_ACCOUNT_SEGMENT11, CHARGE_ACCOUNT_SEGMENT12 CHARGE_ACCOUNT_SEGMENT12, CHARGE_ACCOUNT_SEGMENT13 CHARGE_ACCOUNT_SEGMENT13, CHARGE_ACCOUNT_SEGMENT14 CHARGE_ACCOUNT_SEGMENT14, CHARGE_ACCOUNT_SEGMENT15 CHARGE_ACCOUNT_SEGMENT15, CHARGE_ACCOUNT_SEGMENT16 CHARGE_ACCOUNT_SEGMENT16, CHARGE_ACCOUNT_SEGMENT17 CHARGE_ACCOUNT_SEGMENT17, CHARGE_ACCOUNT_SEGMENT18 CHARGE_ACCOUNT_SEGMENT18, CHARGE_ACCOUNT_SEGMENT19 CHARGE_ACCOUNT_SEGMENT19, CHARGE_ACCOUNT_SEGMENT20 CHARGE_ACCOUNT_SEGMENT20, CHARGE_ACCOUNT_SEGMENT21 CHARGE_ACCOUNT_SEGMENT21, CHARGE_ACCOUNT_SEGMENT22 CHARGE_ACCOUNT_SEGMENT22, CHARGE_ACCOUNT_SEGMENT23 CHARGE_ACCOUNT_SEGMENT23, CHARGE_ACCOUNT_SEGMENT24 CHARGE_ACCOUNT_SEGMENT24, CHARGE_ACCOUNT_SEGMENT25 CHARGE_ACCOUNT_SEGMENT25, CHARGE_ACCOUNT_SEGMENT26 CHARGE_ACCOUNT_SEGMENT26, CHARGE_ACCOUNT_SEGMENT27 CHARGE_ACCOUNT_SEGMENT27, CHARGE_ACCOUNT_SEGMENT28 CHARGE_ACCOUNT_SEGMENT28, CHARGE_ACCOUNT_SEGMENT29 CHARGE_ACCOUNT_SEGMENT29, CHARGE_ACCOUNT_SEGMENT30 CHARGE_ACCOUNT_SEGMENT30, OKE_CONTRACT_LINE_ID OKE_CONTRACT_LINE_ID, OKE_CONTRACT_LINE_NUM OKE_CONTRACT_LINE_NUM, OKE_CONTRACT_DELIVERABLE_ID OKE_CONTRACT_DELIVERABLE_ID, OKE_CONTRACT_DELIVERABLE_NUM OKE_CONTRACT_DELIVERABLE_NUM, AWARD_NUMBER AWARD_NUMBER, AMOUNT_ORDERED AMOUNT_ORDERED, INVOICE_ADJUSTMENT_FLAG INVOICE_ADJUSTMENT_FLAG, DEST_CHARGE_ACCOUNT_ID DEST_CHARGE_ACCOUNT_ID, DEST_VARIANCE_ACCOUNT_ID DEST_VARIANCE_ACCOUNT_ID, INTERFACE_LINE_LOCATION_ID INTERFACE_LINE_LOCATION_ID, PROCESSING_ID PROCESSING_ID, PROCESS_CODE PROCESS_CODE, INTERFACE_DISTRIBUTION_REF INTERFACE_DISTRIBUTION_REF, GROUP_LINE_ID GROUP_LINE_ID, FUNDED_VALUE FUNDED_VALUE, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG, QUANTITY_FUNDED QUANTITY_FUNDED, AMOUNT_FUNDED AMOUNT_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, ACRN ACRN, CLM_PAYMENT_SEQUENCE_NUM CLM_PAYMENT_SEQUENCE_NUM from "PO"."PO_DISTRIBUTIONS_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, INTERFACE_DISTRIBUTION_ID INTERFACE_DISTRIBUTION_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_ID PO_LINE_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, DISTRIBUTION_NUM DISTRIBUTION_NUM
, SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID
, ORG_ID ORG_ID
, QUANTITY_ORDERED QUANTITY_ORDERED
, QUANTITY_DELIVERED QUANTITY_DELIVERED
, QUANTITY_BILLED QUANTITY_BILLED
, QUANTITY_CANCELLED QUANTITY_CANCELLED
, RATE_DATE RATE_DATE
, RATE RATE
, DELIVER_TO_LOCATION DELIVER_TO_LOCATION
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_PERSON_FULL_NAME DELIVER_TO_PERSON_FULL_NAME
, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, DESTINATION_TYPE DESTINATION_TYPE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, DESTINATION_ORGANIZATION DESTINATION_ORGANIZATION
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, DESTINATION_CONTEXT DESTINATION_CONTEXT
, SET_OF_BOOKS SET_OF_BOOKS
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CHARGE_ACCOUNT CHARGE_ACCOUNT
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, BUDGET_ACCOUNT BUDGET_ACCOUNT
, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID
, ACCURAL_ACCOUNT ACCURAL_ACCOUNT
, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT VARIANCE_ACCOUNT
, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID
, AMOUNT_BILLED AMOUNT_BILLED
, ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG
, ACCRUED_FLAG ACCRUED_FLAG
, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, ENCUMBERED_FLAG ENCUMBERED_FLAG
, ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT
, UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY
, UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT
, FAILED_FUNDS FAILED_FUNDS
, 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
, GL_CLOSED_DATE GL_CLOSED_DATE
, REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM
, REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM
, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, WIP_ENTITY WIP_ENTITY
, 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 WIP_REPETITIVE_SCHEDULE
, WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID
, WIP_LINE_CODE WIP_LINE_CODE
, WIP_LINE_ID WIP_LINE_ID
, BOM_RESOURCE_CODE BOM_RESOURCE_CODE
, BOM_RESOURCE_ID BOM_RESOURCE_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, PROJECT PROJECT
, PROJECT_ID PROJECT_ID
, TASK#2 TASK
, TASK_ID TASK_ID
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, EXPENDITURE EXPENDITURE
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION EXPENDITURE_ORGANIZATION
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PROJECT_RELEATED_FLAG PROJECT_RELEATED_FLAG
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, 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
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RECOVERABLE_TAX RECOVERABLE_TAX
, NONRECOVERABLE_TAX NONRECOVERABLE_TAX
, RECOVERY_RATE RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG
, AWARD_ID AWARD_ID
, CHARGE_ACCOUNT_SEGMENT1 CHARGE_ACCOUNT_SEGMENT1
, CHARGE_ACCOUNT_SEGMENT2 CHARGE_ACCOUNT_SEGMENT2
, CHARGE_ACCOUNT_SEGMENT3 CHARGE_ACCOUNT_SEGMENT3
, CHARGE_ACCOUNT_SEGMENT4 CHARGE_ACCOUNT_SEGMENT4
, CHARGE_ACCOUNT_SEGMENT5 CHARGE_ACCOUNT_SEGMENT5
, CHARGE_ACCOUNT_SEGMENT6 CHARGE_ACCOUNT_SEGMENT6
, CHARGE_ACCOUNT_SEGMENT7 CHARGE_ACCOUNT_SEGMENT7
, CHARGE_ACCOUNT_SEGMENT8 CHARGE_ACCOUNT_SEGMENT8
, CHARGE_ACCOUNT_SEGMENT9 CHARGE_ACCOUNT_SEGMENT9
, CHARGE_ACCOUNT_SEGMENT10 CHARGE_ACCOUNT_SEGMENT10
, CHARGE_ACCOUNT_SEGMENT11 CHARGE_ACCOUNT_SEGMENT11
, CHARGE_ACCOUNT_SEGMENT12 CHARGE_ACCOUNT_SEGMENT12
, CHARGE_ACCOUNT_SEGMENT13 CHARGE_ACCOUNT_SEGMENT13
, CHARGE_ACCOUNT_SEGMENT14 CHARGE_ACCOUNT_SEGMENT14
, CHARGE_ACCOUNT_SEGMENT15 CHARGE_ACCOUNT_SEGMENT15
, CHARGE_ACCOUNT_SEGMENT16 CHARGE_ACCOUNT_SEGMENT16
, CHARGE_ACCOUNT_SEGMENT17 CHARGE_ACCOUNT_SEGMENT17
, CHARGE_ACCOUNT_SEGMENT18 CHARGE_ACCOUNT_SEGMENT18
, CHARGE_ACCOUNT_SEGMENT19 CHARGE_ACCOUNT_SEGMENT19
, CHARGE_ACCOUNT_SEGMENT20 CHARGE_ACCOUNT_SEGMENT20
, CHARGE_ACCOUNT_SEGMENT21 CHARGE_ACCOUNT_SEGMENT21
, CHARGE_ACCOUNT_SEGMENT22 CHARGE_ACCOUNT_SEGMENT22
, CHARGE_ACCOUNT_SEGMENT23 CHARGE_ACCOUNT_SEGMENT23
, CHARGE_ACCOUNT_SEGMENT24 CHARGE_ACCOUNT_SEGMENT24
, CHARGE_ACCOUNT_SEGMENT25 CHARGE_ACCOUNT_SEGMENT25
, CHARGE_ACCOUNT_SEGMENT26 CHARGE_ACCOUNT_SEGMENT26
, CHARGE_ACCOUNT_SEGMENT27 CHARGE_ACCOUNT_SEGMENT27
, CHARGE_ACCOUNT_SEGMENT28 CHARGE_ACCOUNT_SEGMENT28
, CHARGE_ACCOUNT_SEGMENT29 CHARGE_ACCOUNT_SEGMENT29
, CHARGE_ACCOUNT_SEGMENT30 CHARGE_ACCOUNT_SEGMENT30
, OKE_CONTRACT_LINE_ID OKE_CONTRACT_LINE_ID
, OKE_CONTRACT_LINE_NUM OKE_CONTRACT_LINE_NUM
, OKE_CONTRACT_DELIVERABLE_ID OKE_CONTRACT_DELIVERABLE_ID
, OKE_CONTRACT_DELIVERABLE_NUM OKE_CONTRACT_DELIVERABLE_NUM
, AWARD_NUMBER AWARD_NUMBER
, AMOUNT_ORDERED AMOUNT_ORDERED
, INVOICE_ADJUSTMENT_FLAG INVOICE_ADJUSTMENT_FLAG
, DEST_CHARGE_ACCOUNT_ID DEST_CHARGE_ACCOUNT_ID
, DEST_VARIANCE_ACCOUNT_ID DEST_VARIANCE_ACCOUNT_ID
, INTERFACE_LINE_LOCATION_ID INTERFACE_LINE_LOCATION_ID
, PROCESSING_ID PROCESSING_ID
, PROCESS_CODE PROCESS_CODE
, INTERFACE_DISTRIBUTION_REF INTERFACE_DISTRIBUTION_REF
, GROUP_LINE_ID GROUP_LINE_ID
, FUNDED_VALUE FUNDED_VALUE
, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG
, QUANTITY_FUNDED QUANTITY_FUNDED
, AMOUNT_FUNDED AMOUNT_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
, ACRN ACRN
, CLM_PAYMENT_SEQUENCE_NUM CLM_PAYMENT_SEQUENCE_NUM
FROM "PO"."PO_DISTRIBUTIONS_INTERFACE"