PO_INTG_DISTRIBUTIONS

Details

Schema: FUSION
Object owner: PO
Object type: VIEW

Columns

Name
PO_DISTRIBUTION_ID BUDGET_DATE CANCEL_BUDGET_DATE CLOSE_BUDGET_DATE FUNDS_STATUS LAST_UPDATE_DATE DIST_INTENDED_USE PRC_BU_ID REQ_BU_ID LAST_UPDATED_BY PO_HEADER_ID PO_LINE_ID LINE_LOCATION_ID SET_OF_BOOKS_ID CODE_COMBINATION_ID PRICING_QUANTITY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY PRICING_QUANTITY_DELIVERED QUANTITY_BILLED PRICING_QUANTITY_CANCELLED CONSIGNMENT_QUANTITY REQ_HEADER_REFERENCE_NUM REQ_LINE_REFERENCE_NUM REQ_DISTRIBUTION_ID DELIVER_TO_LOCATION_ID DELIVER_TO_PERSON_ID RATE_DATE RATE AMOUNT_BILLED ACCRUED_FLAG ENCUMBERED_FLAG ENCUMBERED_AMOUNT UNENCUMBERED_QUANTITY UNENCUMBERED_AMOUNT FAILED_FUNDS_LOOKUP_CODE GL_ENCUMBERED_DATE GL_ENCUMBERED_PERIOD_NAME GL_CANCELLED_DATE DESTINATION_TYPE_CODE DESTINATION_ORGANIZATION_ID DESTINATION_SUBINVENTORY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP10 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 WIP_ENTITY_ID WIP_OPERATION_SEQ_NUM WIP_RESOURCE_SEQ_NUM WIP_REPETITIVE_SCHEDULE_ID WIP_LINE_ID BOM_RESOURCE_ID BUDGET_ACCOUNT_ID ACCRUAL_ACCOUNT_ID VARIANCE_ACCOUNT_ID PREVENT_ENCUMBRANCE_FLAG GOVERNMENT_CONTEXT DESTINATION_CONTEXT DISTRIBUTION_NUM SOURCE_DISTRIBUTION_ID REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PROGRAM_NAME PROGRAM_APP_NAME GL_CLOSED_DATE ACCRUE_ON_RECEIPT_FLAG SOLDTO_BU_ID KANBAN_CARD_ID AWARD_ID END_ITEM_UNIT_NUMBER TAX_RECOVERY_OVERRIDE_FLAG RECOVERABLE_TAX NONRECOVERABLE_TAX RECOVERABLE_INCLUSIVE_TAX NONRECOVERABLE_INCLUSIVE_TAX TAX_EXCLUSIVE_AMOUNT RECOVERY_RATE OKE_CONTRACT_LINE_ID OKE_CONTRACT_DELIVERABLE_ID AMOUNT_ORDERED AMOUNT_DELIVERED AMOUNT_CANCELLED DISTRIBUTION_TYPE AMOUNT_TO_ENCUMBER INVOICE_ADJUSTMENT_FLAG DEST_CHARGE_ACCOUNT_ID DEST_VARIANCE_ACCOUNT_ID QUANTITY_FINANCED AMOUNT_FINANCED QUANTITY_RECOUPED AMOUNT_RECOUPED RETAINAGE_WITHHELD_AMOUNT RETAINAGE_RELEASED_AMOUNT INVOICED_VAL_IN_NTFN TAX_ATTRIBUTE_UPDATE_CODE INTERFACE_DISTRIBUTION_REF OBJECT_VERSION_NUMBER PJC_PROJECT_ID PJC_TASK_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_EXPENDITURE_TYPE_ID PJC_CONTEXT_CATEGORY PJC_BILLABLE_FLAG PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10 PJC_CONTRACT_ID PJC_WORK_TYPE_ID PJC_CAPITALIZABLE_FLAG PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_FUNDING_ALLOCATION_ID PJC_CONTRACT_LINE_ID ORIGINAL_DISTRIBUTION_ID DELIVER_TO_CUST_LOCATION_ID DELIVER_TO_CUST_ID DELIVER_TO_CUST_CONTACT_ID QUANTITY_DELIVERED SECONDARY_QUANTITY_DELIVERED QUANTITY_ORDERED QUANTITY_CANCELLED

Name

PO_DISTRIBUTION_ID

BUDGET_DATE

CANCEL_BUDGET_DATE

CLOSE_BUDGET_DATE

FUNDS_STATUS

LAST_UPDATE_DATE

DIST_INTENDED_USE

PRC_BU_ID

REQ_BU_ID

LAST_UPDATED_BY

PO_HEADER_ID

PO_LINE_ID

LINE_LOCATION_ID

SET_OF_BOOKS_ID

CODE_COMBINATION_ID

PRICING_QUANTITY

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

PRICING_QUANTITY_DELIVERED

QUANTITY_BILLED

PRICING_QUANTITY_CANCELLED

CONSIGNMENT_QUANTITY

REQ_HEADER_REFERENCE_NUM

REQ_LINE_REFERENCE_NUM

REQ_DISTRIBUTION_ID

DELIVER_TO_LOCATION_ID

DELIVER_TO_PERSON_ID

RATE_DATE

RATE

AMOUNT_BILLED

ACCRUED_FLAG

ENCUMBERED_FLAG

ENCUMBERED_AMOUNT

UNENCUMBERED_QUANTITY

UNENCUMBERED_AMOUNT

FAILED_FUNDS_LOOKUP_CODE

GL_ENCUMBERED_DATE

GL_ENCUMBERED_PERIOD_NAME

GL_CANCELLED_DATE

DESTINATION_TYPE_CODE

DESTINATION_ORGANIZATION_ID

DESTINATION_SUBINVENTORY

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

ATTRIBUTE_TIMESTAMP6

ATTRIBUTE_TIMESTAMP7

ATTRIBUTE_TIMESTAMP8

ATTRIBUTE_TIMESTAMP9

ATTRIBUTE_TIMESTAMP10

GLOBAL_ATTRIBUTE_CATEGORY

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

GLOBAL_ATTRIBUTE_DATE1

GLOBAL_ATTRIBUTE_DATE2

GLOBAL_ATTRIBUTE_DATE3

GLOBAL_ATTRIBUTE_DATE4

GLOBAL_ATTRIBUTE_DATE5

GLOBAL_ATTRIBUTE_NUMBER1

GLOBAL_ATTRIBUTE_NUMBER2

GLOBAL_ATTRIBUTE_NUMBER3

GLOBAL_ATTRIBUTE_NUMBER4

GLOBAL_ATTRIBUTE_NUMBER5

WIP_ENTITY_ID

WIP_OPERATION_SEQ_NUM

WIP_RESOURCE_SEQ_NUM

WIP_REPETITIVE_SCHEDULE_ID

WIP_LINE_ID

BOM_RESOURCE_ID

BUDGET_ACCOUNT_ID

ACCRUAL_ACCOUNT_ID

VARIANCE_ACCOUNT_ID

PREVENT_ENCUMBRANCE_FLAG

GOVERNMENT_CONTEXT

DESTINATION_CONTEXT

DISTRIBUTION_NUM

SOURCE_DISTRIBUTION_ID

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

PROGRAM_NAME

PROGRAM_APP_NAME

GL_CLOSED_DATE

ACCRUE_ON_RECEIPT_FLAG

SOLDTO_BU_ID

KANBAN_CARD_ID

AWARD_ID

END_ITEM_UNIT_NUMBER

TAX_RECOVERY_OVERRIDE_FLAG

RECOVERABLE_TAX

NONRECOVERABLE_TAX

RECOVERABLE_INCLUSIVE_TAX

NONRECOVERABLE_INCLUSIVE_TAX

TAX_EXCLUSIVE_AMOUNT

RECOVERY_RATE

OKE_CONTRACT_LINE_ID

OKE_CONTRACT_DELIVERABLE_ID

AMOUNT_ORDERED

AMOUNT_DELIVERED

AMOUNT_CANCELLED

DISTRIBUTION_TYPE

AMOUNT_TO_ENCUMBER

INVOICE_ADJUSTMENT_FLAG

DEST_CHARGE_ACCOUNT_ID

DEST_VARIANCE_ACCOUNT_ID

QUANTITY_FINANCED

AMOUNT_FINANCED

QUANTITY_RECOUPED

AMOUNT_RECOUPED

RETAINAGE_WITHHELD_AMOUNT

RETAINAGE_RELEASED_AMOUNT

INVOICED_VAL_IN_NTFN

TAX_ATTRIBUTE_UPDATE_CODE

INTERFACE_DISTRIBUTION_REF

OBJECT_VERSION_NUMBER

PJC_PROJECT_ID

PJC_TASK_ID

PJC_EXPENDITURE_ITEM_DATE

PJC_ORGANIZATION_ID

PJC_EXPENDITURE_TYPE_ID

PJC_CONTEXT_CATEGORY

PJC_BILLABLE_FLAG

PJC_USER_DEF_ATTRIBUTE1

PJC_USER_DEF_ATTRIBUTE2

PJC_USER_DEF_ATTRIBUTE3

PJC_USER_DEF_ATTRIBUTE4

PJC_USER_DEF_ATTRIBUTE5

PJC_USER_DEF_ATTRIBUTE6

PJC_USER_DEF_ATTRIBUTE7

PJC_USER_DEF_ATTRIBUTE8

PJC_USER_DEF_ATTRIBUTE9

PJC_USER_DEF_ATTRIBUTE10

PJC_CONTRACT_ID

PJC_WORK_TYPE_ID

PJC_CAPITALIZABLE_FLAG

PJC_RESERVED_ATTRIBUTE1

PJC_RESERVED_ATTRIBUTE2

PJC_RESERVED_ATTRIBUTE3

PJC_RESERVED_ATTRIBUTE4

PJC_RESERVED_ATTRIBUTE5

PJC_RESERVED_ATTRIBUTE6

PJC_RESERVED_ATTRIBUTE7

PJC_RESERVED_ATTRIBUTE8

PJC_RESERVED_ATTRIBUTE9

PJC_RESERVED_ATTRIBUTE10

PJC_FUNDING_ALLOCATION_ID

PJC_CONTRACT_LINE_ID

ORIGINAL_DISTRIBUTION_ID

DELIVER_TO_CUST_LOCATION_ID

DELIVER_TO_CUST_ID

DELIVER_TO_CUST_CONTACT_ID

QUANTITY_DELIVERED

SECONDARY_QUANTITY_DELIVERED

QUANTITY_ORDERED

QUANTITY_CANCELLED

Query

SQL_Statement
SELECT PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, PO_DISTRIBUTIONS_ALL.BUDGET_DATE BUDGET_DATE, PO_DISTRIBUTIONS_ALL.CANCEL_BUDGET_DATE CANCEL_BUDGET_DATE, PO_DISTRIBUTIONS_ALL.CLOSE_BUDGET_DATE CLOSE_BUDGET_DATE, PO_DISTRIBUTIONS_ALL.FUNDS_STATUS FUNDS_STATUS, PO_DISTRIBUTIONS_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE, PO_DISTRIBUTIONS_ALL.DIST_INTENDED_USE DIST_INTENDED_USE, PO_DISTRIBUTIONS_ALL.PRC_BU_ID PRC_BU_ID, PO_DISTRIBUTIONS_ALL.REQ_BU_ID REQ_BU_ID, PO_DISTRIBUTIONS_ALL.LAST_UPDATED_BY LAST_UPDATED_BY, PO_DISTRIBUTIONS_ALL.PO_HEADER_ID PO_HEADER_ID, PO_DISTRIBUTIONS_ALL.PO_LINE_ID PO_LINE_ID, PO_DISTRIBUTIONS_ALL.LINE_LOCATION_ID LINE_LOCATION_ID, PO_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID CODE_COMBINATION_ID, PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED PRICING_QUANTITY, PO_DISTRIBUTIONS_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PO_DISTRIBUTIONS_ALL.CREATION_DATE CREATION_DATE, PO_DISTRIBUTIONS_ALL.CREATED_BY CREATED_BY, PO_DISTRIBUTIONS_ALL.QUANTITY_DELIVERED PRICING_QUANTITY_DELIVERED, PO_DISTRIBUTIONS_ALL.QUANTITY_BILLED QUANTITY_BILLED, PO_DISTRIBUTIONS_ALL.QUANTITY_CANCELLED PRICING_QUANTITY_CANCELLED, PO_DISTRIBUTIONS_ALL.CONSIGNMENT_QUANTITY CONSIGNMENT_QUANTITY, PO_DISTRIBUTIONS_ALL.REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM, PO_DISTRIBUTIONS_ALL.REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM, PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, PO_DISTRIBUTIONS_ALL.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, PO_DISTRIBUTIONS_ALL.DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID, PO_DISTRIBUTIONS_ALL.RATE_DATE RATE_DATE, PO_DISTRIBUTIONS_ALL.RATE RATE, PO_DISTRIBUTIONS_ALL.AMOUNT_BILLED AMOUNT_BILLED, PO_DISTRIBUTIONS_ALL.ACCRUED_FLAG ACCRUED_FLAG, PO_DISTRIBUTIONS_ALL.ENCUMBERED_FLAG ENCUMBERED_FLAG, PO_DISTRIBUTIONS_ALL.ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT, PO_DISTRIBUTIONS_ALL.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY, PO_DISTRIBUTIONS_ALL.UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT, PO_DISTRIBUTIONS_ALL.FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE, PO_DISTRIBUTIONS_ALL.GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE, PO_DISTRIBUTIONS_ALL.GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME, PO_DISTRIBUTIONS_ALL.GL_CANCELLED_DATE GL_CANCELLED_DATE, PO_DISTRIBUTIONS_ALL.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, PO_DISTRIBUTIONS_ALL.DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, PO_DISTRIBUTIONS_ALL.DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PO_DISTRIBUTIONS_ALL.ATTRIBUTE1 ATTRIBUTE1, PO_DISTRIBUTIONS_ALL.ATTRIBUTE2 ATTRIBUTE2, PO_DISTRIBUTIONS_ALL.ATTRIBUTE3 ATTRIBUTE3, PO_DISTRIBUTIONS_ALL.ATTRIBUTE4 ATTRIBUTE4, PO_DISTRIBUTIONS_ALL.ATTRIBUTE5 ATTRIBUTE5, PO_DISTRIBUTIONS_ALL.ATTRIBUTE6 ATTRIBUTE6, PO_DISTRIBUTIONS_ALL.ATTRIBUTE7 ATTRIBUTE7, PO_DISTRIBUTIONS_ALL.ATTRIBUTE8 ATTRIBUTE8, PO_DISTRIBUTIONS_ALL.ATTRIBUTE9 ATTRIBUTE9, PO_DISTRIBUTIONS_ALL.ATTRIBUTE10 ATTRIBUTE10, PO_DISTRIBUTIONS_ALL.ATTRIBUTE11 ATTRIBUTE11, PO_DISTRIBUTIONS_ALL.ATTRIBUTE12 ATTRIBUTE12, PO_DISTRIBUTIONS_ALL.ATTRIBUTE13 ATTRIBUTE13, PO_DISTRIBUTIONS_ALL.ATTRIBUTE14 ATTRIBUTE14, PO_DISTRIBUTIONS_ALL.ATTRIBUTE15 ATTRIBUTE15, PO_DISTRIBUTIONS_ALL.ATTRIBUTE16 ATTRIBUTE16, PO_DISTRIBUTIONS_ALL.ATTRIBUTE17 ATTRIBUTE17, PO_DISTRIBUTIONS_ALL.ATTRIBUTE18 ATTRIBUTE18, PO_DISTRIBUTIONS_ALL.ATTRIBUTE19 ATTRIBUTE19, PO_DISTRIBUTIONS_ALL.ATTRIBUTE20 ATTRIBUTE20, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9, PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE1, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE2, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE3, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE4, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE5, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER1, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER2, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER3, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER4, PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER5, PO_DISTRIBUTIONS_ALL.WIP_ENTITY_ID WIP_ENTITY_ID, PO_DISTRIBUTIONS_ALL.WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM, PO_DISTRIBUTIONS_ALL.WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM, PO_DISTRIBUTIONS_ALL.WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID, PO_DISTRIBUTIONS_ALL.WIP_LINE_ID WIP_LINE_ID, PO_DISTRIBUTIONS_ALL.BOM_RESOURCE_ID BOM_RESOURCE_ID, PO_DISTRIBUTIONS_ALL.BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID, PO_DISTRIBUTIONS_ALL.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, PO_DISTRIBUTIONS_ALL.VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID, PO_DISTRIBUTIONS_ALL.PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, PO_DISTRIBUTIONS_ALL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, PO_DISTRIBUTIONS_ALL.DESTINATION_CONTEXT DESTINATION_CONTEXT, PO_DISTRIBUTIONS_ALL.DISTRIBUTION_NUM DISTRIBUTION_NUM, PO_DISTRIBUTIONS_ALL.SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID, PO_DISTRIBUTIONS_ALL.REQUEST_ID REQUEST_ID, PO_DISTRIBUTIONS_ALL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, PO_DISTRIBUTIONS_ALL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, PO_DISTRIBUTIONS_ALL.PROGRAM_NAME PROGRAM_NAME, PO_DISTRIBUTIONS_ALL.PROGRAM_APP_NAME PROGRAM_APP_NAME, PO_DISTRIBUTIONS_ALL.GL_CLOSED_DATE GL_CLOSED_DATE, PO_DISTRIBUTIONS_ALL.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG, PO_DISTRIBUTIONS_ALL.SOLDTO_BU_ID SOLDTO_BU_ID, PO_DISTRIBUTIONS_ALL.KANBAN_CARD_ID KANBAN_CARD_ID, PO_DISTRIBUTIONS_ALL.AWARD_ID AWARD_ID, PO_DISTRIBUTIONS_ALL.END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, PO_DISTRIBUTIONS_ALL.TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG, PO_DISTRIBUTIONS_ALL.RECOVERABLE_TAX RECOVERABLE_TAX, PO_DISTRIBUTIONS_ALL.NONRECOVERABLE_TAX NONRECOVERABLE_TAX, PO_DISTRIBUTIONS_ALL.RECOVERABLE_INCLUSIVE_TAX RECOVERABLE_INCLUSIVE_TAX, PO_DISTRIBUTIONS_ALL.NONRECOVERABLE_INCLUSIVE_TAX NONRECOVERABLE_INCLUSIVE_TAX, PO_DISTRIBUTIONS_ALL.TAX_EXCLUSIVE_AMOUNT TAX_EXCLUSIVE_AMOUNT, PO_DISTRIBUTIONS_ALL.RECOVERY_RATE RECOVERY_RATE, PO_DISTRIBUTIONS_ALL.OKE_CONTRACT_LINE_ID OKE_CONTRACT_LINE_ID, PO_DISTRIBUTIONS_ALL.OKE_CONTRACT_DELIVERABLE_ID OKE_CONTRACT_DELIVERABLE_ID, PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED AMOUNT_ORDERED, PO_DISTRIBUTIONS_ALL.AMOUNT_DELIVERED AMOUNT_DELIVERED, PO_DISTRIBUTIONS_ALL.AMOUNT_CANCELLED AMOUNT_CANCELLED, PO_DISTRIBUTIONS_ALL.DISTRIBUTION_TYPE DISTRIBUTION_TYPE, PO_DISTRIBUTIONS_ALL.AMOUNT_TO_ENCUMBER AMOUNT_TO_ENCUMBER, PO_DISTRIBUTIONS_ALL.INVOICE_ADJUSTMENT_FLAG INVOICE_ADJUSTMENT_FLAG, PO_DISTRIBUTIONS_ALL.DEST_CHARGE_ACCOUNT_ID DEST_CHARGE_ACCOUNT_ID, PO_DISTRIBUTIONS_ALL.DEST_VARIANCE_ACCOUNT_ID DEST_VARIANCE_ACCOUNT_ID, PO_DISTRIBUTIONS_ALL.QUANTITY_FINANCED QUANTITY_FINANCED, PO_DISTRIBUTIONS_ALL.AMOUNT_FINANCED AMOUNT_FINANCED, PO_DISTRIBUTIONS_ALL.QUANTITY_RECOUPED QUANTITY_RECOUPED, PO_DISTRIBUTIONS_ALL.AMOUNT_RECOUPED AMOUNT_RECOUPED, PO_DISTRIBUTIONS_ALL.RETAINAGE_WITHHELD_AMOUNT RETAINAGE_WITHHELD_AMOUNT, PO_DISTRIBUTIONS_ALL.RETAINAGE_RELEASED_AMOUNT RETAINAGE_RELEASED_AMOUNT, PO_DISTRIBUTIONS_ALL.INVOICED_VAL_IN_NTFN INVOICED_VAL_IN_NTFN, PO_DISTRIBUTIONS_ALL.TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, PO_DISTRIBUTIONS_ALL.INTERFACE_DISTRIBUTION_REF INTERFACE_DISTRIBUTION_REF, PO_DISTRIBUTIONS_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PO_DISTRIBUTIONS_ALL.PJC_PROJECT_ID PJC_PROJECT_ID, PO_DISTRIBUTIONS_ALL.PJC_TASK_ID PJC_TASK_ID, PO_DISTRIBUTIONS_ALL.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE, PO_DISTRIBUTIONS_ALL.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID, PO_DISTRIBUTIONS_ALL.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID, PO_DISTRIBUTIONS_ALL.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY, PO_DISTRIBUTIONS_ALL.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE1, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9, PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10, PO_DISTRIBUTIONS_ALL.PJC_CONTRACT_ID PJC_CONTRACT_ID, PO_DISTRIBUTIONS_ALL.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID, PO_DISTRIBUTIONS_ALL.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9, PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10, PO_DISTRIBUTIONS_ALL.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID, PO_DISTRIBUTIONS_ALL.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID, PO_DISTRIBUTIONS_ALL.ORIGINAL_DISTRIBUTION_ID ORIGINAL_DISTRIBUTION_ID, PO_DISTRIBUTIONS_ALL.DELIVER_TO_CUST_LOCATION_ID DELIVER_TO_CUST_LOCATION_ID, PO_DISTRIBUTIONS_ALL.DELIVER_TO_CUST_ID DELIVER_TO_CUST_ID, PO_DISTRIBUTIONS_ALL.DELIVER_TO_CUST_CONTACT_ID DELIVER_TO_CUST_CONTACT_ID, PO_DISTRIBUTIONS_ALL.SHIPPING_UOM_QTY_DELIVERED QUANTITY_DELIVERED, PO_DISTRIBUTIONS_ALL.SECONDARY_QUANTITY_DELIVERED SECONDARY_QUANTITY_DELIVERED, PO_DISTRIBUTIONS_ALL.SHIPPING_UOM_QUANTITY QUANTITY_ORDERED, PO_DISTRIBUTIONS_ALL.SHIPPING_UOM_QUANTITY_CANCELED QUANTITY_CANCELLED FROM PO_DISTRIBUTIONS_ALL

SQL_Statement

SELECT

PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID,

PO_DISTRIBUTIONS_ALL.BUDGET_DATE BUDGET_DATE,

PO_DISTRIBUTIONS_ALL.CANCEL_BUDGET_DATE CANCEL_BUDGET_DATE,

PO_DISTRIBUTIONS_ALL.CLOSE_BUDGET_DATE CLOSE_BUDGET_DATE,

PO_DISTRIBUTIONS_ALL.FUNDS_STATUS FUNDS_STATUS,

PO_DISTRIBUTIONS_ALL.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PO_DISTRIBUTIONS_ALL.DIST_INTENDED_USE DIST_INTENDED_USE,

PO_DISTRIBUTIONS_ALL.PRC_BU_ID PRC_BU_ID,

PO_DISTRIBUTIONS_ALL.REQ_BU_ID REQ_BU_ID,

PO_DISTRIBUTIONS_ALL.LAST_UPDATED_BY LAST_UPDATED_BY,

PO_DISTRIBUTIONS_ALL.PO_HEADER_ID PO_HEADER_ID,

PO_DISTRIBUTIONS_ALL.PO_LINE_ID PO_LINE_ID,

PO_DISTRIBUTIONS_ALL.LINE_LOCATION_ID LINE_LOCATION_ID,

PO_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID,

PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID CODE_COMBINATION_ID,

PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED PRICING_QUANTITY,

PO_DISTRIBUTIONS_ALL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PO_DISTRIBUTIONS_ALL.CREATION_DATE CREATION_DATE,

PO_DISTRIBUTIONS_ALL.CREATED_BY CREATED_BY,

PO_DISTRIBUTIONS_ALL.QUANTITY_DELIVERED PRICING_QUANTITY_DELIVERED,

PO_DISTRIBUTIONS_ALL.QUANTITY_BILLED QUANTITY_BILLED,

PO_DISTRIBUTIONS_ALL.QUANTITY_CANCELLED PRICING_QUANTITY_CANCELLED,

PO_DISTRIBUTIONS_ALL.CONSIGNMENT_QUANTITY CONSIGNMENT_QUANTITY,

PO_DISTRIBUTIONS_ALL.REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM,

PO_DISTRIBUTIONS_ALL.REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM,

PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID,

PO_DISTRIBUTIONS_ALL.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID,

PO_DISTRIBUTIONS_ALL.DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID,

PO_DISTRIBUTIONS_ALL.RATE_DATE RATE_DATE,

PO_DISTRIBUTIONS_ALL.RATE RATE,

PO_DISTRIBUTIONS_ALL.AMOUNT_BILLED AMOUNT_BILLED,

PO_DISTRIBUTIONS_ALL.ACCRUED_FLAG ACCRUED_FLAG,

PO_DISTRIBUTIONS_ALL.ENCUMBERED_FLAG ENCUMBERED_FLAG,

PO_DISTRIBUTIONS_ALL.ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT,

PO_DISTRIBUTIONS_ALL.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY,

PO_DISTRIBUTIONS_ALL.UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT,

PO_DISTRIBUTIONS_ALL.FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE,

PO_DISTRIBUTIONS_ALL.GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE,

PO_DISTRIBUTIONS_ALL.GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME,

PO_DISTRIBUTIONS_ALL.GL_CANCELLED_DATE GL_CANCELLED_DATE,

PO_DISTRIBUTIONS_ALL.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE,

PO_DISTRIBUTIONS_ALL.DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID,

PO_DISTRIBUTIONS_ALL.DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE1 ATTRIBUTE1,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE2 ATTRIBUTE2,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE3 ATTRIBUTE3,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE4 ATTRIBUTE4,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE5 ATTRIBUTE5,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE6 ATTRIBUTE6,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE7 ATTRIBUTE7,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE8 ATTRIBUTE8,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE9 ATTRIBUTE9,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE10 ATTRIBUTE10,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE11 ATTRIBUTE11,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE12 ATTRIBUTE12,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE13 ATTRIBUTE13,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE14 ATTRIBUTE14,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE15 ATTRIBUTE15,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE16 ATTRIBUTE16,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE17 ATTRIBUTE17,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE18 ATTRIBUTE18,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE19 ATTRIBUTE19,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE20 ATTRIBUTE20,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP6,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP7,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP8,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP9 ATTRIBUTE_TIMESTAMP9,

PO_DISTRIBUTIONS_ALL.ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP10,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE1,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE2,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE3,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE4,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE5,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER1,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER2,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER3,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER4,

PO_DISTRIBUTIONS_ALL.GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER5,

PO_DISTRIBUTIONS_ALL.WIP_ENTITY_ID WIP_ENTITY_ID,

PO_DISTRIBUTIONS_ALL.WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM,

PO_DISTRIBUTIONS_ALL.WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM,

PO_DISTRIBUTIONS_ALL.WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID,

PO_DISTRIBUTIONS_ALL.WIP_LINE_ID WIP_LINE_ID,

PO_DISTRIBUTIONS_ALL.BOM_RESOURCE_ID BOM_RESOURCE_ID,

PO_DISTRIBUTIONS_ALL.BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID,

PO_DISTRIBUTIONS_ALL.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID,

PO_DISTRIBUTIONS_ALL.VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID,

PO_DISTRIBUTIONS_ALL.PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG,

PO_DISTRIBUTIONS_ALL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT,

PO_DISTRIBUTIONS_ALL.DESTINATION_CONTEXT DESTINATION_CONTEXT,

PO_DISTRIBUTIONS_ALL.DISTRIBUTION_NUM DISTRIBUTION_NUM,

PO_DISTRIBUTIONS_ALL.SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID,

PO_DISTRIBUTIONS_ALL.REQUEST_ID REQUEST_ID,

PO_DISTRIBUTIONS_ALL.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

PO_DISTRIBUTIONS_ALL.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE,

PO_DISTRIBUTIONS_ALL.PROGRAM_NAME PROGRAM_NAME,

PO_DISTRIBUTIONS_ALL.PROGRAM_APP_NAME PROGRAM_APP_NAME,

PO_DISTRIBUTIONS_ALL.GL_CLOSED_DATE GL_CLOSED_DATE,

PO_DISTRIBUTIONS_ALL.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG,

PO_DISTRIBUTIONS_ALL.SOLDTO_BU_ID SOLDTO_BU_ID,

PO_DISTRIBUTIONS_ALL.KANBAN_CARD_ID KANBAN_CARD_ID,

PO_DISTRIBUTIONS_ALL.AWARD_ID AWARD_ID,

PO_DISTRIBUTIONS_ALL.END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER,

PO_DISTRIBUTIONS_ALL.TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG,

PO_DISTRIBUTIONS_ALL.RECOVERABLE_TAX RECOVERABLE_TAX,

PO_DISTRIBUTIONS_ALL.NONRECOVERABLE_TAX NONRECOVERABLE_TAX,

PO_DISTRIBUTIONS_ALL.RECOVERABLE_INCLUSIVE_TAX RECOVERABLE_INCLUSIVE_TAX,

PO_DISTRIBUTIONS_ALL.NONRECOVERABLE_INCLUSIVE_TAX NONRECOVERABLE_INCLUSIVE_TAX,

PO_DISTRIBUTIONS_ALL.TAX_EXCLUSIVE_AMOUNT TAX_EXCLUSIVE_AMOUNT,

PO_DISTRIBUTIONS_ALL.RECOVERY_RATE RECOVERY_RATE,

PO_DISTRIBUTIONS_ALL.OKE_CONTRACT_LINE_ID OKE_CONTRACT_LINE_ID,

PO_DISTRIBUTIONS_ALL.OKE_CONTRACT_DELIVERABLE_ID OKE_CONTRACT_DELIVERABLE_ID,

PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED AMOUNT_ORDERED,

PO_DISTRIBUTIONS_ALL.AMOUNT_DELIVERED AMOUNT_DELIVERED,

PO_DISTRIBUTIONS_ALL.AMOUNT_CANCELLED AMOUNT_CANCELLED,

PO_DISTRIBUTIONS_ALL.DISTRIBUTION_TYPE DISTRIBUTION_TYPE,

PO_DISTRIBUTIONS_ALL.AMOUNT_TO_ENCUMBER AMOUNT_TO_ENCUMBER,

PO_DISTRIBUTIONS_ALL.INVOICE_ADJUSTMENT_FLAG INVOICE_ADJUSTMENT_FLAG,

PO_DISTRIBUTIONS_ALL.DEST_CHARGE_ACCOUNT_ID DEST_CHARGE_ACCOUNT_ID,

PO_DISTRIBUTIONS_ALL.DEST_VARIANCE_ACCOUNT_ID DEST_VARIANCE_ACCOUNT_ID,

PO_DISTRIBUTIONS_ALL.QUANTITY_FINANCED QUANTITY_FINANCED,

PO_DISTRIBUTIONS_ALL.AMOUNT_FINANCED AMOUNT_FINANCED,

PO_DISTRIBUTIONS_ALL.QUANTITY_RECOUPED QUANTITY_RECOUPED,

PO_DISTRIBUTIONS_ALL.AMOUNT_RECOUPED AMOUNT_RECOUPED,

PO_DISTRIBUTIONS_ALL.RETAINAGE_WITHHELD_AMOUNT RETAINAGE_WITHHELD_AMOUNT,

PO_DISTRIBUTIONS_ALL.RETAINAGE_RELEASED_AMOUNT RETAINAGE_RELEASED_AMOUNT,

PO_DISTRIBUTIONS_ALL.INVOICED_VAL_IN_NTFN INVOICED_VAL_IN_NTFN,

PO_DISTRIBUTIONS_ALL.TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE,

PO_DISTRIBUTIONS_ALL.INTERFACE_DISTRIBUTION_REF INTERFACE_DISTRIBUTION_REF,

PO_DISTRIBUTIONS_ALL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PO_DISTRIBUTIONS_ALL.PJC_PROJECT_ID PJC_PROJECT_ID,

PO_DISTRIBUTIONS_ALL.PJC_TASK_ID PJC_TASK_ID,

PO_DISTRIBUTIONS_ALL.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE,

PO_DISTRIBUTIONS_ALL.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID,

PO_DISTRIBUTIONS_ALL.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID,

PO_DISTRIBUTIONS_ALL.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY,

PO_DISTRIBUTIONS_ALL.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE1,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9,

PO_DISTRIBUTIONS_ALL.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10,

PO_DISTRIBUTIONS_ALL.PJC_CONTRACT_ID PJC_CONTRACT_ID,

PO_DISTRIBUTIONS_ALL.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID,

PO_DISTRIBUTIONS_ALL.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9,

PO_DISTRIBUTIONS_ALL.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10,

PO_DISTRIBUTIONS_ALL.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID,

PO_DISTRIBUTIONS_ALL.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID,

PO_DISTRIBUTIONS_ALL.ORIGINAL_DISTRIBUTION_ID ORIGINAL_DISTRIBUTION_ID,

PO_DISTRIBUTIONS_ALL.DELIVER_TO_CUST_LOCATION_ID DELIVER_TO_CUST_LOCATION_ID,

PO_DISTRIBUTIONS_ALL.DELIVER_TO_CUST_ID DELIVER_TO_CUST_ID,

PO_DISTRIBUTIONS_ALL.DELIVER_TO_CUST_CONTACT_ID DELIVER_TO_CUST_CONTACT_ID,

PO_DISTRIBUTIONS_ALL.SHIPPING_UOM_QTY_DELIVERED QUANTITY_DELIVERED,

PO_DISTRIBUTIONS_ALL.SECONDARY_QUANTITY_DELIVERED SECONDARY_QUANTITY_DELIVERED,

PO_DISTRIBUTIONS_ALL.SHIPPING_UOM_QUANTITY QUANTITY_ORDERED,

PO_DISTRIBUTIONS_ALL.SHIPPING_UOM_QUANTITY_CANCELED QUANTITY_CANCELLED

FROM

PO_DISTRIBUTIONS_ALL