VIEW: PO.PO_REQ_DIST_INTERFACE_ALL#

Source

View Text - Preformatted

select ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, ALLOCATION_TYPE ALLOCATION_TYPE, ALLOCATION_VALUE ALLOCATION_VALUE, BATCH_ID BATCH_ID, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, CHARGE_ACCOUNT_SEGMENT1 CHARGE_ACCOUNT_SEGMENT1, 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_SEGMENT2 CHARGE_ACCOUNT_SEGMENT2, 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_SEGMENT3 CHARGE_ACCOUNT_SEGMENT3, CHARGE_ACCOUNT_SEGMENT30 CHARGE_ACCOUNT_SEGMENT30, 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, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, DISTRIBUTION_ATTRIBUTE1 DISTRIBUTION_ATTRIBUTE1, DISTRIBUTION_ATTRIBUTE10 DISTRIBUTION_ATTRIBUTE10, DISTRIBUTION_ATTRIBUTE11 DISTRIBUTION_ATTRIBUTE11, DISTRIBUTION_ATTRIBUTE12 DISTRIBUTION_ATTRIBUTE12, DISTRIBUTION_ATTRIBUTE13 DISTRIBUTION_ATTRIBUTE13, DISTRIBUTION_ATTRIBUTE14 DISTRIBUTION_ATTRIBUTE14, DISTRIBUTION_ATTRIBUTE15 DISTRIBUTION_ATTRIBUTE15, DISTRIBUTION_ATTRIBUTE2 DISTRIBUTION_ATTRIBUTE2, DISTRIBUTION_ATTRIBUTE3 DISTRIBUTION_ATTRIBUTE3, DISTRIBUTION_ATTRIBUTE4 DISTRIBUTION_ATTRIBUTE4, DISTRIBUTION_ATTRIBUTE5 DISTRIBUTION_ATTRIBUTE5, DISTRIBUTION_ATTRIBUTE6 DISTRIBUTION_ATTRIBUTE6, DISTRIBUTION_ATTRIBUTE7 DISTRIBUTION_ATTRIBUTE7, DISTRIBUTION_ATTRIBUTE8 DISTRIBUTION_ATTRIBUTE8, DISTRIBUTION_ATTRIBUTE9 DISTRIBUTION_ATTRIBUTE9, DISTRIBUTION_NUMBER DISTRIBUTION_NUMBER, DIST_ATTRIBUTE_CATEGORY DIST_ATTRIBUTE_CATEGORY, DIST_SEQUENCE_ID DIST_SEQUENCE_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, GL_DATE GL_DATE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, GROUP_CODE GROUP_CODE, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID, ITEM_ID ITEM_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_ID ORG_ID, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, PROCESS_FLAG PROCESS_FLAG, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, PROJECT_ID PROJECT_ID, PROJECT_NUM PROJECT_NUM, QUANTITY QUANTITY, REQUEST_ID REQUEST_ID, REQUISITION_HEADER_ID REQUISITION_HEADER_ID, REQ_NUMBER_SEGMENT1 REQ_NUMBER_SEGMENT1, REQUISITION_LINE_ID REQUISITION_LINE_ID, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, TASK_ID TASK_ID, TASK_NUM#1 TASK_NUM, TRANSACTION_ID TRANSACTION_ID, UPDATE_ENABLED_FLAG UPDATE_ENABLED_FLAG, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID, 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, AMOUNT AMOUNT, CURRENCY_AMOUNT CURRENCY_AMOUNT, FUNDED_VALUE FUNDED_VALUE, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG from "PO"."PO_REQ_DIST_INTERFACE_ALL"

View Text - HTML Formatted

SELECT ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, ALLOCATION_TYPE ALLOCATION_TYPE
, ALLOCATION_VALUE ALLOCATION_VALUE
, BATCH_ID BATCH_ID
, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, CHARGE_ACCOUNT_SEGMENT1 CHARGE_ACCOUNT_SEGMENT1
, 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_SEGMENT2 CHARGE_ACCOUNT_SEGMENT2
, 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_SEGMENT3 CHARGE_ACCOUNT_SEGMENT3
, CHARGE_ACCOUNT_SEGMENT30 CHARGE_ACCOUNT_SEGMENT30
, 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
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, DISTRIBUTION_ATTRIBUTE1 DISTRIBUTION_ATTRIBUTE1
, DISTRIBUTION_ATTRIBUTE10 DISTRIBUTION_ATTRIBUTE10
, DISTRIBUTION_ATTRIBUTE11 DISTRIBUTION_ATTRIBUTE11
, DISTRIBUTION_ATTRIBUTE12 DISTRIBUTION_ATTRIBUTE12
, DISTRIBUTION_ATTRIBUTE13 DISTRIBUTION_ATTRIBUTE13
, DISTRIBUTION_ATTRIBUTE14 DISTRIBUTION_ATTRIBUTE14
, DISTRIBUTION_ATTRIBUTE15 DISTRIBUTION_ATTRIBUTE15
, DISTRIBUTION_ATTRIBUTE2 DISTRIBUTION_ATTRIBUTE2
, DISTRIBUTION_ATTRIBUTE3 DISTRIBUTION_ATTRIBUTE3
, DISTRIBUTION_ATTRIBUTE4 DISTRIBUTION_ATTRIBUTE4
, DISTRIBUTION_ATTRIBUTE5 DISTRIBUTION_ATTRIBUTE5
, DISTRIBUTION_ATTRIBUTE6 DISTRIBUTION_ATTRIBUTE6
, DISTRIBUTION_ATTRIBUTE7 DISTRIBUTION_ATTRIBUTE7
, DISTRIBUTION_ATTRIBUTE8 DISTRIBUTION_ATTRIBUTE8
, DISTRIBUTION_ATTRIBUTE9 DISTRIBUTION_ATTRIBUTE9
, DISTRIBUTION_NUMBER DISTRIBUTION_NUMBER
, DIST_ATTRIBUTE_CATEGORY DIST_ATTRIBUTE_CATEGORY
, DIST_SEQUENCE_ID DIST_SEQUENCE_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, GL_DATE GL_DATE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, GROUP_CODE GROUP_CODE
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID
, ITEM_ID ITEM_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_ID ORG_ID
, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, PROCESS_FLAG PROCESS_FLAG
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, PROJECT_ID PROJECT_ID
, PROJECT_NUM PROJECT_NUM
, QUANTITY QUANTITY
, REQUEST_ID REQUEST_ID
, REQUISITION_HEADER_ID REQUISITION_HEADER_ID
, REQ_NUMBER_SEGMENT1 REQ_NUMBER_SEGMENT1
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, TASK_ID TASK_ID
, TASK_NUM#1 TASK_NUM
, TRANSACTION_ID TRANSACTION_ID
, UPDATE_ENABLED_FLAG UPDATE_ENABLED_FLAG
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID
, 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
, AMOUNT AMOUNT
, CURRENCY_AMOUNT CURRENCY_AMOUNT
, FUNDED_VALUE FUNDED_VALUE
, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG
FROM "PO"."PO_REQ_DIST_INTERFACE_ALL"