VIEW: PO.PO_REQUISITIONS_INTERFACE_ALL#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, PROCESS_FLAG PROCESS_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, REQUISITION_HEADER_ID REQUISITION_HEADER_ID, REQUISITION_LINE_ID REQUISITION_LINE_ID, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, REQUISITION_TYPE REQUISITION_TYPE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, ITEM_DESCRIPTION ITEM_DESCRIPTION, QUANTITY QUANTITY, UNIT_PRICE UNIT_PRICE, AUTHORIZATION_STATUS AUTHORIZATION_STATUS, BATCH_ID BATCH_ID, GROUP_CODE GROUP_CODE, DELETE_ENABLED_FLAG DELETE_ENABLED_FLAG, UPDATE_ENABLED_FLAG UPDATE_ENABLED_FLAG, APPROVER_ID APPROVER_ID, APPROVER_NAME APPROVER_NAME, APPROVAL_PATH_ID APPROVAL_PATH_ID, NOTE_TO_APPROVER#1 NOTE_TO_APPROVER, PREPARER_ID PREPARER_ID, AUTOSOURCE_FLAG AUTOSOURCE_FLAG, REQ_NUMBER_SEGMENT1 REQ_NUMBER_SEGMENT1, REQ_NUMBER_SEGMENT2 REQ_NUMBER_SEGMENT2, REQ_NUMBER_SEGMENT3 REQ_NUMBER_SEGMENT3, REQ_NUMBER_SEGMENT4 REQ_NUMBER_SEGMENT4, REQ_NUMBER_SEGMENT5 REQ_NUMBER_SEGMENT5, HEADER_DESCRIPTION HEADER_DESCRIPTION, HEADER_ATTRIBUTE_CATEGORY HEADER_ATTRIBUTE_CATEGORY, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14, URGENT_FLAG URGENT_FLAG, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG, JUSTIFICATION JUSTIFICATION, NOTE_TO_BUYER NOTE_TO_BUYER, NOTE_TO_RECEIVER NOTE_TO_RECEIVER, ITEM_ID ITEM_ID, ITEM_SEGMENT1 ITEM_SEGMENT1, ITEM_SEGMENT2 ITEM_SEGMENT2, ITEM_SEGMENT3 ITEM_SEGMENT3, ITEM_SEGMENT4 ITEM_SEGMENT4, ITEM_SEGMENT5 ITEM_SEGMENT5, ITEM_SEGMENT6 ITEM_SEGMENT6, ITEM_SEGMENT7 ITEM_SEGMENT7, ITEM_SEGMENT8 ITEM_SEGMENT8, ITEM_SEGMENT9 ITEM_SEGMENT9, ITEM_SEGMENT10 ITEM_SEGMENT10, ITEM_SEGMENT11 ITEM_SEGMENT11, ITEM_SEGMENT12 ITEM_SEGMENT12, ITEM_SEGMENT13 ITEM_SEGMENT13, ITEM_SEGMENT14 ITEM_SEGMENT14, ITEM_SEGMENT15 ITEM_SEGMENT15, ITEM_SEGMENT16 ITEM_SEGMENT16, ITEM_SEGMENT17 ITEM_SEGMENT17, ITEM_SEGMENT18 ITEM_SEGMENT18, ITEM_SEGMENT19 ITEM_SEGMENT19, ITEM_SEGMENT20 ITEM_SEGMENT20, ITEM_REVISION ITEM_REVISION, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_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, CATEGORY_ID CATEGORY_ID, CATEGORY_SEGMENT1 CATEGORY_SEGMENT1, CATEGORY_SEGMENT2 CATEGORY_SEGMENT2, CATEGORY_SEGMENT3 CATEGORY_SEGMENT3, CATEGORY_SEGMENT4 CATEGORY_SEGMENT4, CATEGORY_SEGMENT5 CATEGORY_SEGMENT5, CATEGORY_SEGMENT6 CATEGORY_SEGMENT6, CATEGORY_SEGMENT7 CATEGORY_SEGMENT7, CATEGORY_SEGMENT8 CATEGORY_SEGMENT8, CATEGORY_SEGMENT9 CATEGORY_SEGMENT9, CATEGORY_SEGMENT10 CATEGORY_SEGMENT10, CATEGORY_SEGMENT11 CATEGORY_SEGMENT11, CATEGORY_SEGMENT12 CATEGORY_SEGMENT12, CATEGORY_SEGMENT13 CATEGORY_SEGMENT13, CATEGORY_SEGMENT14 CATEGORY_SEGMENT14, CATEGORY_SEGMENT15 CATEGORY_SEGMENT15, CATEGORY_SEGMENT16 CATEGORY_SEGMENT16, CATEGORY_SEGMENT17 CATEGORY_SEGMENT17, CATEGORY_SEGMENT18 CATEGORY_SEGMENT18, CATEGORY_SEGMENT19 CATEGORY_SEGMENT19, CATEGORY_SEGMENT20 CATEGORY_SEGMENT20, UNIT_OF_MEASURE UNIT_OF_MEASURE, UOM_CODE UOM_CODE, LINE_TYPE_ID LINE_TYPE_ID, LINE_TYPE LINE_TYPE, UN_NUMBER_ID UN_NUMBER_ID, UN_NUMBER UN_NUMBER, HAZARD_CLASS_ID HAZARD_CLASS_ID, HAZARD_CLASS HAZARD_CLASS, MUST_USE_SUGG_VENDOR_FLAG MUST_USE_SUGG_VENDOR_FLAG, REFERENCE_NUM REFERENCE_NUM, WIP_ENTITY_ID WIP_ENTITY_ID, WIP_LINE_ID WIP_LINE_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, PROJECT_NUM PROJECT_NUM, TASK_NUM#1 TASK_NUM, EXPENDITURE_TYPE EXPENDITURE_TYPE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID, DESTINATION_ORGANIZATION_CODE DESTINATION_ORGANIZATION_CODE, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, DELIVER_TO_LOCATION_CODE DELIVER_TO_LOCATION_CODE, DELIVER_TO_REQUESTOR_ID DELIVER_TO_REQUESTOR_ID, DELIVER_TO_REQUESTOR_NAME DELIVER_TO_REQUESTOR_NAME, SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID, SUGGESTED_BUYER_NAME SUGGESTED_BUYER_NAME, SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_ID SUGGESTED_VENDOR_ID, SUGGESTED_VENDOR_SITE#1 SUGGESTED_VENDOR_SITE, SUGGESTED_VENDOR_SITE_ID SUGGESTED_VENDOR_SITE_ID, SUGGESTED_VENDOR_CONTACT SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_CONTACT_ID SUGGESTED_VENDOR_CONTACT_ID, SUGGESTED_VENDOR_PHONE SUGGESTED_VENDOR_PHONE, SUGGESTED_VENDOR_ITEM_NUM SUGGESTED_VENDOR_ITEM_NUM, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15, NEED_BY_DATE NEED_BY_DATE, NOTE1_ID NOTE1_ID, NOTE2_ID NOTE2_ID, NOTE3_ID NOTE3_ID, NOTE4_ID NOTE4_ID, NOTE5_ID NOTE5_ID, NOTE6_ID NOTE6_ID, NOTE7_ID NOTE7_ID, NOTE8_ID NOTE8_ID, NOTE9_ID NOTE9_ID, NOTE10_ID NOTE10_ID, NOTE1_TITLE NOTE1_TITLE, NOTE2_TITLE NOTE2_TITLE, NOTE3_TITLE NOTE3_TITLE, NOTE4_TITLE NOTE4_TITLE, NOTE5_TITLE NOTE5_TITLE, NOTE6_TITLE NOTE6_TITLE, NOTE7_TITLE NOTE7_TITLE, NOTE8_TITLE NOTE8_TITLE, NOTE9_TITLE NOTE9_TITLE, NOTE10_TITLE NOTE10_TITLE, GL_DATE GL_DATE, DIST_ATTRIBUTE_CATEGORY DIST_ATTRIBUTE_CATEGORY, DISTRIBUTION_ATTRIBUTE1 DISTRIBUTION_ATTRIBUTE1, 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_ATTRIBUTE10 DISTRIBUTION_ATTRIBUTE10, DISTRIBUTION_ATTRIBUTE11 DISTRIBUTION_ATTRIBUTE11, DISTRIBUTION_ATTRIBUTE12 DISTRIBUTION_ATTRIBUTE12, DISTRIBUTION_ATTRIBUTE13 DISTRIBUTION_ATTRIBUTE13, DISTRIBUTION_ATTRIBUTE14 DISTRIBUTION_ATTRIBUTE14, DISTRIBUTION_ATTRIBUTE15 DISTRIBUTION_ATTRIBUTE15, PREPARER_NAME PREPARER_NAME, BOM_RESOURCE_ID BOM_RESOURCE_ID, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, CURRENCY_CODE CURRENCY_CODE, CURRENCY_UNIT_PRICE CURRENCY_UNIT_PRICE, RATE RATE, RATE_DATE RATE_DATE, RATE_TYPE RATE_TYPE, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG, AUTOSOURCE_DOC_HEADER_ID AUTOSOURCE_DOC_HEADER_ID, AUTOSOURCE_DOC_LINE_NUM AUTOSOURCE_DOC_LINE_NUM, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE, ORG_ID ORG_ID, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE, ALLOCATION_TYPE ALLOCATION_TYPE, ALLOCATION_VALUE ALLOCATION_VALUE, MULTI_DISTRIBUTIONS MULTI_DISTRIBUTIONS, REQ_DIST_SEQUENCE_ID REQ_DIST_SEQUENCE_ID, KANBAN_CARD_ID KANBAN_CARD_ID, EMERGENCY_PO_NUM EMERGENCY_PO_NUM, AWARD_ID AWARD_ID, TAX_CODE_ID TAX_CODE_ID, OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID, OKE_CONTRACT_NUM OKE_CONTRACT_NUM, OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_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, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, SECONDARY_UOM_CODE SECONDARY_UOM_CODE, SECONDARY_QUANTITY SECONDARY_QUANTITY, PREFERRED_GRADE PREFERRED_GRADE, VMI_FLAG VMI_FLAG, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG, AMOUNT AMOUNT, CURRENCY_AMOUNT CURRENCY_AMOUNT, SHIP_METHOD SHIP_METHOD, ESTIMATED_PICKUP_DATE ESTIMATED_PICKUP_DATE, BASE_UNIT_PRICE BASE_UNIT_PRICE, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG, TAX_NAME TAX_NAME, FUNDED_VALUE FUNDED_VALUE, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG, FEDERAL_FLAG FEDERAL_FLAG from "PO"."PO_REQUISITIONS_INTERFACE_ALL"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, PROCESS_FLAG PROCESS_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, REQUISITION_HEADER_ID REQUISITION_HEADER_ID
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, REQUISITION_TYPE REQUISITION_TYPE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, QUANTITY QUANTITY
, UNIT_PRICE UNIT_PRICE
, AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, BATCH_ID BATCH_ID
, GROUP_CODE GROUP_CODE
, DELETE_ENABLED_FLAG DELETE_ENABLED_FLAG
, UPDATE_ENABLED_FLAG UPDATE_ENABLED_FLAG
, APPROVER_ID APPROVER_ID
, APPROVER_NAME APPROVER_NAME
, APPROVAL_PATH_ID APPROVAL_PATH_ID
, NOTE_TO_APPROVER#1 NOTE_TO_APPROVER
, PREPARER_ID PREPARER_ID
, AUTOSOURCE_FLAG AUTOSOURCE_FLAG
, REQ_NUMBER_SEGMENT1 REQ_NUMBER_SEGMENT1
, REQ_NUMBER_SEGMENT2 REQ_NUMBER_SEGMENT2
, REQ_NUMBER_SEGMENT3 REQ_NUMBER_SEGMENT3
, REQ_NUMBER_SEGMENT4 REQ_NUMBER_SEGMENT4
, REQ_NUMBER_SEGMENT5 REQ_NUMBER_SEGMENT5
, HEADER_DESCRIPTION HEADER_DESCRIPTION
, HEADER_ATTRIBUTE_CATEGORY HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14
, URGENT_FLAG URGENT_FLAG
, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15
, RFQ_REQUIRED_FLAG RFQ_REQUIRED_FLAG
, JUSTIFICATION JUSTIFICATION
, NOTE_TO_BUYER NOTE_TO_BUYER
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, ITEM_ID ITEM_ID
, ITEM_SEGMENT1 ITEM_SEGMENT1
, ITEM_SEGMENT2 ITEM_SEGMENT2
, ITEM_SEGMENT3 ITEM_SEGMENT3
, ITEM_SEGMENT4 ITEM_SEGMENT4
, ITEM_SEGMENT5 ITEM_SEGMENT5
, ITEM_SEGMENT6 ITEM_SEGMENT6
, ITEM_SEGMENT7 ITEM_SEGMENT7
, ITEM_SEGMENT8 ITEM_SEGMENT8
, ITEM_SEGMENT9 ITEM_SEGMENT9
, ITEM_SEGMENT10 ITEM_SEGMENT10
, ITEM_SEGMENT11 ITEM_SEGMENT11
, ITEM_SEGMENT12 ITEM_SEGMENT12
, ITEM_SEGMENT13 ITEM_SEGMENT13
, ITEM_SEGMENT14 ITEM_SEGMENT14
, ITEM_SEGMENT15 ITEM_SEGMENT15
, ITEM_SEGMENT16 ITEM_SEGMENT16
, ITEM_SEGMENT17 ITEM_SEGMENT17
, ITEM_SEGMENT18 ITEM_SEGMENT18
, ITEM_SEGMENT19 ITEM_SEGMENT19
, ITEM_SEGMENT20 ITEM_SEGMENT20
, ITEM_REVISION ITEM_REVISION
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_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
, CATEGORY_ID CATEGORY_ID
, CATEGORY_SEGMENT1 CATEGORY_SEGMENT1
, CATEGORY_SEGMENT2 CATEGORY_SEGMENT2
, CATEGORY_SEGMENT3 CATEGORY_SEGMENT3
, CATEGORY_SEGMENT4 CATEGORY_SEGMENT4
, CATEGORY_SEGMENT5 CATEGORY_SEGMENT5
, CATEGORY_SEGMENT6 CATEGORY_SEGMENT6
, CATEGORY_SEGMENT7 CATEGORY_SEGMENT7
, CATEGORY_SEGMENT8 CATEGORY_SEGMENT8
, CATEGORY_SEGMENT9 CATEGORY_SEGMENT9
, CATEGORY_SEGMENT10 CATEGORY_SEGMENT10
, CATEGORY_SEGMENT11 CATEGORY_SEGMENT11
, CATEGORY_SEGMENT12 CATEGORY_SEGMENT12
, CATEGORY_SEGMENT13 CATEGORY_SEGMENT13
, CATEGORY_SEGMENT14 CATEGORY_SEGMENT14
, CATEGORY_SEGMENT15 CATEGORY_SEGMENT15
, CATEGORY_SEGMENT16 CATEGORY_SEGMENT16
, CATEGORY_SEGMENT17 CATEGORY_SEGMENT17
, CATEGORY_SEGMENT18 CATEGORY_SEGMENT18
, CATEGORY_SEGMENT19 CATEGORY_SEGMENT19
, CATEGORY_SEGMENT20 CATEGORY_SEGMENT20
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, UOM_CODE UOM_CODE
, LINE_TYPE_ID LINE_TYPE_ID
, LINE_TYPE LINE_TYPE
, UN_NUMBER_ID UN_NUMBER_ID
, UN_NUMBER UN_NUMBER
, HAZARD_CLASS_ID HAZARD_CLASS_ID
, HAZARD_CLASS HAZARD_CLASS
, MUST_USE_SUGG_VENDOR_FLAG MUST_USE_SUGG_VENDOR_FLAG
, REFERENCE_NUM REFERENCE_NUM
, WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_LINE_ID WIP_LINE_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
, PROJECT_NUM PROJECT_NUM
, TASK_NUM#1 TASK_NUM
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
, SOURCE_SUBINVENTORY SOURCE_SUBINVENTORY
, DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, DESTINATION_ORGANIZATION_CODE DESTINATION_ORGANIZATION_CODE
, DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, DELIVER_TO_LOCATION_CODE DELIVER_TO_LOCATION_CODE
, DELIVER_TO_REQUESTOR_ID DELIVER_TO_REQUESTOR_ID
, DELIVER_TO_REQUESTOR_NAME DELIVER_TO_REQUESTOR_NAME
, SUGGESTED_BUYER_ID SUGGESTED_BUYER_ID
, SUGGESTED_BUYER_NAME SUGGESTED_BUYER_NAME
, SUGGESTED_VENDOR_NAME SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_ID SUGGESTED_VENDOR_ID
, SUGGESTED_VENDOR_SITE#1 SUGGESTED_VENDOR_SITE
, SUGGESTED_VENDOR_SITE_ID SUGGESTED_VENDOR_SITE_ID
, SUGGESTED_VENDOR_CONTACT SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_CONTACT_ID SUGGESTED_VENDOR_CONTACT_ID
, SUGGESTED_VENDOR_PHONE SUGGESTED_VENDOR_PHONE
, SUGGESTED_VENDOR_ITEM_NUM SUGGESTED_VENDOR_ITEM_NUM
, LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, NEED_BY_DATE NEED_BY_DATE
, NOTE1_ID NOTE1_ID
, NOTE2_ID NOTE2_ID
, NOTE3_ID NOTE3_ID
, NOTE4_ID NOTE4_ID
, NOTE5_ID NOTE5_ID
, NOTE6_ID NOTE6_ID
, NOTE7_ID NOTE7_ID
, NOTE8_ID NOTE8_ID
, NOTE9_ID NOTE9_ID
, NOTE10_ID NOTE10_ID
, NOTE1_TITLE NOTE1_TITLE
, NOTE2_TITLE NOTE2_TITLE
, NOTE3_TITLE NOTE3_TITLE
, NOTE4_TITLE NOTE4_TITLE
, NOTE5_TITLE NOTE5_TITLE
, NOTE6_TITLE NOTE6_TITLE
, NOTE7_TITLE NOTE7_TITLE
, NOTE8_TITLE NOTE8_TITLE
, NOTE9_TITLE NOTE9_TITLE
, NOTE10_TITLE NOTE10_TITLE
, GL_DATE GL_DATE
, DIST_ATTRIBUTE_CATEGORY DIST_ATTRIBUTE_CATEGORY
, DISTRIBUTION_ATTRIBUTE1 DISTRIBUTION_ATTRIBUTE1
, 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_ATTRIBUTE10 DISTRIBUTION_ATTRIBUTE10
, DISTRIBUTION_ATTRIBUTE11 DISTRIBUTION_ATTRIBUTE11
, DISTRIBUTION_ATTRIBUTE12 DISTRIBUTION_ATTRIBUTE12
, DISTRIBUTION_ATTRIBUTE13 DISTRIBUTION_ATTRIBUTE13
, DISTRIBUTION_ATTRIBUTE14 DISTRIBUTION_ATTRIBUTE14
, DISTRIBUTION_ATTRIBUTE15 DISTRIBUTION_ATTRIBUTE15
, PREPARER_NAME PREPARER_NAME
, BOM_RESOURCE_ID BOM_RESOURCE_ID
, ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID
, BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_UNIT_PRICE CURRENCY_UNIT_PRICE
, RATE RATE
, RATE_DATE RATE_DATE
, RATE_TYPE RATE_TYPE
, PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, AUTOSOURCE_DOC_HEADER_ID AUTOSOURCE_DOC_HEADER_ID
, AUTOSOURCE_DOC_LINE_NUM AUTOSOURCE_DOC_LINE_NUM
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE
, ORG_ID ORG_ID
, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, ALLOCATION_TYPE ALLOCATION_TYPE
, ALLOCATION_VALUE ALLOCATION_VALUE
, MULTI_DISTRIBUTIONS MULTI_DISTRIBUTIONS
, REQ_DIST_SEQUENCE_ID REQ_DIST_SEQUENCE_ID
, KANBAN_CARD_ID KANBAN_CARD_ID
, EMERGENCY_PO_NUM EMERGENCY_PO_NUM
, AWARD_ID AWARD_ID
, TAX_CODE_ID TAX_CODE_ID
, OKE_CONTRACT_HEADER_ID OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_NUM OKE_CONTRACT_NUM
, OKE_CONTRACT_VERSION_ID OKE_CONTRACT_VERSION_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
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, PREFERRED_GRADE PREFERRED_GRADE
, VMI_FLAG VMI_FLAG
, TAX_USER_OVERRIDE_FLAG TAX_USER_OVERRIDE_FLAG
, AMOUNT AMOUNT
, CURRENCY_AMOUNT CURRENCY_AMOUNT
, SHIP_METHOD SHIP_METHOD
, ESTIMATED_PICKUP_DATE ESTIMATED_PICKUP_DATE
, BASE_UNIT_PRICE BASE_UNIT_PRICE
, NEGOTIATED_BY_PREPARER_FLAG NEGOTIATED_BY_PREPARER_FLAG
, TAX_NAME TAX_NAME
, FUNDED_VALUE FUNDED_VALUE
, PARTIAL_FUNDED_FLAG PARTIAL_FUNDED_FLAG
, FEDERAL_FLAG FEDERAL_FLAG
FROM "PO"."PO_REQUISITIONS_INTERFACE_ALL"