VIEW: PO.PO_HEADERS_ARCHIVE_ALL#

Source

View Text - Preformatted

select PO_HEADER_ID PO_HEADER_ID, AGENT_ID AGENT_ID, TYPE_LOOKUP_CODE TYPE_LOOKUP_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SEGMENT1 SEGMENT1, SUMMARY_FLAG SUMMARY_FLAG, ENABLED_FLAG ENABLED_FLAG, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_CONTACT_ID VENDOR_CONTACT_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, TERMS_ID TERMS_ID, SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE, FOB_LOOKUP_CODE FOB_LOOKUP_CODE, FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE, CURRENCY_CODE CURRENCY_CODE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, RATE RATE, FROM_HEADER_ID FROM_HEADER_ID, FROM_TYPE_LOOKUP_CODE FROM_TYPE_LOOKUP_CODE, START_DATE START_DATE, END_DATE END_DATE, BLANKET_TOTAL_AMOUNT BLANKET_TOTAL_AMOUNT, AUTHORIZATION_STATUS AUTHORIZATION_STATUS, REVISION_NUM REVISION_NUM, REVISED_DATE REVISED_DATE, APPROVED_FLAG APPROVED_FLAG, APPROVED_DATE APPROVED_DATE, AMOUNT_LIMIT AMOUNT_LIMIT, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT, NOTE_TO_AUTHORIZER NOTE_TO_AUTHORIZER, NOTE_TO_VENDOR NOTE_TO_VENDOR, NOTE_TO_RECEIVER NOTE_TO_RECEIVER, PRINT_COUNT PRINT_COUNT, PRINTED_DATE PRINTED_DATE, VENDOR_ORDER_NUM VENDOR_ORDER_NUM, CONFIRMING_ORDER_FLAG CONFIRMING_ORDER_FLAG, COMMENTS COMMENTS, REPLY_DATE REPLY_DATE, REPLY_METHOD_LOOKUP_CODE REPLY_METHOD_LOOKUP_CODE, RFQ_CLOSE_DATE RFQ_CLOSE_DATE, QUOTE_TYPE_LOOKUP_CODE QUOTE_TYPE_LOOKUP_CODE, QUOTATION_CLASS_CODE QUOTATION_CLASS_CODE, QUOTE_WARNING_DELAY_UNIT QUOTE_WARNING_DELAY_UNIT, QUOTE_WARNING_DELAY QUOTE_WARNING_DELAY, QUOTE_VENDOR_QUOTE_NUMBER QUOTE_VENDOR_QUOTE_NUMBER, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG, ACCEPTANCE_DUE_DATE ACCEPTANCE_DUE_DATE, CLOSED_DATE CLOSED_DATE, USER_HOLD_FLAG USER_HOLD_FLAG, EVER_APPROVED_FLAG EVER_APPROVED_FLAG, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG, CANCEL_FLAG CANCEL_FLAG, STANDARD_COMMENT_CODE STANDARD_COMMENT_CODE, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE, FIRM_DATE FIRM_DATE, FROZEN_FLAG FROZEN_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, CLOSED_CODE CLOSED_CODE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, ORG_ID ORG_ID, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG, PCARD_ID PCARD_ID, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE, SUPPLY_AGREEMENT_FLAG SUPPLY_AGREEMENT_FLAG, EDI_PROCESSED_STATUS EDI_PROCESSED_STATUS, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, REFERENCE_NUM REFERENCE_NUM, WF_ITEM_TYPE WF_ITEM_TYPE, WF_ITEM_KEY WF_ITEM_KEY, MRC_RATE_TYPE MRC_RATE_TYPE, MRC_RATE_DATE MRC_RATE_DATE, MRC_RATE MRC_RATE, PAY_ON_CODE PAY_ON_CODE, XML_FLAG XML_FLAG, XML_SEND_DATE XML_SEND_DATE, XML_CHANGE_SEND_DATE XML_CHANGE_SEND_DATE, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG, CONSIGNED_CONSUMPTION_FLAG CONSIGNED_CONSUMPTION_FLAG, CBC_ACCOUNTING_DATE CBC_ACCOUNTING_DATE, CONSUME_REQ_DEMAND_FLAG CONSUME_REQ_DEMAND_FLAG, CHANGE_REQUESTED_BY CHANGE_REQUESTED_BY, CONTERMS_EXIST_FLAG CONTERMS_EXIST_FLAG, CONTERMS_ARTICLES_UPD_DATE CONTERMS_ARTICLES_UPD_DATE, ENCUMBRANCE_REQUIRED_FLAG ENCUMBRANCE_REQUIRED_FLAG, CONTERMS_DELIV_UPD_DATE CONTERMS_DELIV_UPD_DATE, SHIPPING_CONTROL SHIPPING_CONTROL, PENDING_SIGNATURE_FLAG PENDING_SIGNATURE_FLAG, CHANGE_SUMMARY CHANGE_SUMMARY, DOCUMENT_CREATION_METHOD DOCUMENT_CREATION_METHOD, SUBMIT_DATE SUBMIT_DATE, SUPPLIER_NOTIF_METHOD SUPPLIER_NOTIF_METHOD, FAX FAX, EMAIL_ADDRESS EMAIL_ADDRESS, RETRO_PRICE_COMM_UPDATES_FLAG RETRO_PRICE_COMM_UPDATES_FLAG, RETRO_PRICE_APPLY_UPDATES_FLAG RETRO_PRICE_APPLY_UPDATES_FLAG, UPDATE_SOURCING_RULES_FLAG UPDATE_SOURCING_RULES_FLAG, AUTO_SOURCING_FLAG AUTO_SOURCING_FLAG, CREATED_LANGUAGE CREATED_LANGUAGE, CPA_REFERENCE CPA_REFERENCE, SUPPLIER_AUTH_ENABLED_FLAG SUPPLIER_AUTH_ENABLED_FLAG, CAT_ADMIN_AUTH_ENABLED_FLAG CAT_ADMIN_AUTH_ENABLED_FLAG, STYLE_ID STYLE_ID, LAST_UPDATED_PROGRAM LAST_UPDATED_PROGRAM, PAY_WHEN_PAID PAY_WHEN_PAID, USER_DOCUMENT_STATUS USER_DOCUMENT_STATUS, AME_APPROVAL_ID AME_APPROVAL_ID, CLM_DOCUMENT_NUMBER CLM_DOCUMENT_NUMBER, AME_TRANSACTION_TYPE AME_TRANSACTION_TYPE, CLM_AMOUNT_RELEASED CLM_AMOUNT_RELEASED, CLM_AMT_SYNCED_TO_AGREEMENT CLM_AMT_SYNCED_TO_AGREEMENT, CLM_AWARD_ADMINISTRATOR CLM_AWARD_ADMINISTRATOR, CLM_AWARD_TYPE CLM_AWARD_TYPE, CLM_CLOSEOUT_STATUS CLM_CLOSEOUT_STATUS, CLM_CONTRACT_OFFICER CLM_CONTRACT_OFFICER, CLM_COTR_CONTACT CLM_COTR_CONTACT, CLM_COTR_OFFICE CLM_COTR_OFFICE, CLM_DOCUMENT_FORMAT CLM_DOCUMENT_FORMAT, CLM_EFFECTIVE_DATE CLM_EFFECTIVE_DATE, CLM_EXTERNAL_IDV CLM_EXTERNAL_IDV, CLM_ISSUING_OFFICE CLM_ISSUING_OFFICE, CLM_MAX_ORDER_AMOUNT CLM_MAX_ORDER_AMOUNT, CLM_MIN_GUARANTEE_AWARD_AMT CLM_MIN_GUARANTEE_AWARD_AMT, CLM_MIN_GUAR_AWARD_AMT_PERCENT CLM_MIN_GUAR_AWARD_AMT_PERCENT, CLM_MIN_ORDER_AMOUNT CLM_MIN_ORDER_AMOUNT, CLM_MOD_ISSUING_OFFICE CLM_MOD_ISSUING_OFFICE, CLM_NO_SIGNED_COPIES_TO_RETURN CLM_NO_SIGNED_COPIES_TO_RETURN, CLM_PRIORITY_CODE CLM_PRIORITY_CODE, CLM_SOURCE_DOCUMENT_ID CLM_SOURCE_DOCUMENT_ID, CLM_STANDARD_FORM CLM_STANDARD_FORM, CLM_SUPPLIER_NAME CLM_SUPPLIER_NAME, CLM_SUPPLIER_SITE_NAME CLM_SUPPLIER_SITE_NAME, CLM_VENDOR_OFFER_NUMBER CLM_VENDOR_OFFER_NUMBER, COMM_REV_NUM COMM_REV_NUM, DRAFT_ID DRAFT_ID, ENABLE_ALL_SITES ENABLE_ALL_SITES, OTM_RECOVERY_FLAG OTM_RECOVERY_FLAG, OTM_STATUS_CODE OTM_STATUS_CODE, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, UMBRELLA_PROGRAM_ID UMBRELLA_PROGRAM_ID, FON_REF_ID FON_REF_ID, CLM_CONTRACT_FINANCE_CODE CLM_CONTRACT_FINANCE_CODE, CLM_PAYMENT_INSTR_CODE CLM_PAYMENT_INSTR_CODE, CLM_SPECIAL_CONTRACT_TYPE CLM_SPECIAL_CONTRACT_TYPE from "PO"."PO_HEADERS_ARCHIVE_ALL"

View Text - HTML Formatted

SELECT PO_HEADER_ID PO_HEADER_ID
, AGENT_ID AGENT_ID
, TYPE_LOOKUP_CODE TYPE_LOOKUP_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SEGMENT1 SEGMENT1
, SUMMARY_FLAG SUMMARY_FLAG
, ENABLED_FLAG ENABLED_FLAG
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, TERMS_ID TERMS_ID
, SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE
, FOB_LOOKUP_CODE FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE
, STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE
, CURRENCY_CODE CURRENCY_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, RATE RATE
, FROM_HEADER_ID FROM_HEADER_ID
, FROM_TYPE_LOOKUP_CODE FROM_TYPE_LOOKUP_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, BLANKET_TOTAL_AMOUNT BLANKET_TOTAL_AMOUNT
, AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, REVISION_NUM REVISION_NUM
, REVISED_DATE REVISED_DATE
, APPROVED_FLAG APPROVED_FLAG
, APPROVED_DATE APPROVED_DATE
, AMOUNT_LIMIT AMOUNT_LIMIT
, MIN_RELEASE_AMOUNT MIN_RELEASE_AMOUNT
, NOTE_TO_AUTHORIZER NOTE_TO_AUTHORIZER
, NOTE_TO_VENDOR NOTE_TO_VENDOR
, NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, PRINT_COUNT PRINT_COUNT
, PRINTED_DATE PRINTED_DATE
, VENDOR_ORDER_NUM VENDOR_ORDER_NUM
, CONFIRMING_ORDER_FLAG CONFIRMING_ORDER_FLAG
, COMMENTS COMMENTS
, REPLY_DATE REPLY_DATE
, REPLY_METHOD_LOOKUP_CODE REPLY_METHOD_LOOKUP_CODE
, RFQ_CLOSE_DATE RFQ_CLOSE_DATE
, QUOTE_TYPE_LOOKUP_CODE QUOTE_TYPE_LOOKUP_CODE
, QUOTATION_CLASS_CODE QUOTATION_CLASS_CODE
, QUOTE_WARNING_DELAY_UNIT QUOTE_WARNING_DELAY_UNIT
, QUOTE_WARNING_DELAY QUOTE_WARNING_DELAY
, QUOTE_VENDOR_QUOTE_NUMBER QUOTE_VENDOR_QUOTE_NUMBER
, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG
, ACCEPTANCE_DUE_DATE ACCEPTANCE_DUE_DATE
, CLOSED_DATE CLOSED_DATE
, USER_HOLD_FLAG USER_HOLD_FLAG
, EVER_APPROVED_FLAG EVER_APPROVED_FLAG
, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG
, CANCEL_FLAG CANCEL_FLAG
, STANDARD_COMMENT_CODE STANDARD_COMMENT_CODE
, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE FIRM_DATE
, FROZEN_FLAG FROZEN_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, CLOSED_CODE CLOSED_CODE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, ORG_ID ORG_ID
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG
, PCARD_ID PCARD_ID
, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE
, SUPPLY_AGREEMENT_FLAG SUPPLY_AGREEMENT_FLAG
, EDI_PROCESSED_STATUS EDI_PROCESSED_STATUS
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, REFERENCE_NUM REFERENCE_NUM
, WF_ITEM_TYPE WF_ITEM_TYPE
, WF_ITEM_KEY WF_ITEM_KEY
, MRC_RATE_TYPE MRC_RATE_TYPE
, MRC_RATE_DATE MRC_RATE_DATE
, MRC_RATE MRC_RATE
, PAY_ON_CODE PAY_ON_CODE
, XML_FLAG XML_FLAG
, XML_SEND_DATE XML_SEND_DATE
, XML_CHANGE_SEND_DATE XML_CHANGE_SEND_DATE
, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG
, CONSIGNED_CONSUMPTION_FLAG CONSIGNED_CONSUMPTION_FLAG
, CBC_ACCOUNTING_DATE CBC_ACCOUNTING_DATE
, CONSUME_REQ_DEMAND_FLAG CONSUME_REQ_DEMAND_FLAG
, CHANGE_REQUESTED_BY CHANGE_REQUESTED_BY
, CONTERMS_EXIST_FLAG CONTERMS_EXIST_FLAG
, CONTERMS_ARTICLES_UPD_DATE CONTERMS_ARTICLES_UPD_DATE
, ENCUMBRANCE_REQUIRED_FLAG ENCUMBRANCE_REQUIRED_FLAG
, CONTERMS_DELIV_UPD_DATE CONTERMS_DELIV_UPD_DATE
, SHIPPING_CONTROL SHIPPING_CONTROL
, PENDING_SIGNATURE_FLAG PENDING_SIGNATURE_FLAG
, CHANGE_SUMMARY CHANGE_SUMMARY
, DOCUMENT_CREATION_METHOD DOCUMENT_CREATION_METHOD
, SUBMIT_DATE SUBMIT_DATE
, SUPPLIER_NOTIF_METHOD SUPPLIER_NOTIF_METHOD
, FAX FAX
, EMAIL_ADDRESS EMAIL_ADDRESS
, RETRO_PRICE_COMM_UPDATES_FLAG RETRO_PRICE_COMM_UPDATES_FLAG
, RETRO_PRICE_APPLY_UPDATES_FLAG RETRO_PRICE_APPLY_UPDATES_FLAG
, UPDATE_SOURCING_RULES_FLAG UPDATE_SOURCING_RULES_FLAG
, AUTO_SOURCING_FLAG AUTO_SOURCING_FLAG
, CREATED_LANGUAGE CREATED_LANGUAGE
, CPA_REFERENCE CPA_REFERENCE
, SUPPLIER_AUTH_ENABLED_FLAG SUPPLIER_AUTH_ENABLED_FLAG
, CAT_ADMIN_AUTH_ENABLED_FLAG CAT_ADMIN_AUTH_ENABLED_FLAG
, STYLE_ID STYLE_ID
, LAST_UPDATED_PROGRAM LAST_UPDATED_PROGRAM
, PAY_WHEN_PAID PAY_WHEN_PAID
, USER_DOCUMENT_STATUS USER_DOCUMENT_STATUS
, AME_APPROVAL_ID AME_APPROVAL_ID
, CLM_DOCUMENT_NUMBER CLM_DOCUMENT_NUMBER
, AME_TRANSACTION_TYPE AME_TRANSACTION_TYPE
, CLM_AMOUNT_RELEASED CLM_AMOUNT_RELEASED
, CLM_AMT_SYNCED_TO_AGREEMENT CLM_AMT_SYNCED_TO_AGREEMENT
, CLM_AWARD_ADMINISTRATOR CLM_AWARD_ADMINISTRATOR
, CLM_AWARD_TYPE CLM_AWARD_TYPE
, CLM_CLOSEOUT_STATUS CLM_CLOSEOUT_STATUS
, CLM_CONTRACT_OFFICER CLM_CONTRACT_OFFICER
, CLM_COTR_CONTACT CLM_COTR_CONTACT
, CLM_COTR_OFFICE CLM_COTR_OFFICE
, CLM_DOCUMENT_FORMAT CLM_DOCUMENT_FORMAT
, CLM_EFFECTIVE_DATE CLM_EFFECTIVE_DATE
, CLM_EXTERNAL_IDV CLM_EXTERNAL_IDV
, CLM_ISSUING_OFFICE CLM_ISSUING_OFFICE
, CLM_MAX_ORDER_AMOUNT CLM_MAX_ORDER_AMOUNT
, CLM_MIN_GUARANTEE_AWARD_AMT CLM_MIN_GUARANTEE_AWARD_AMT
, CLM_MIN_GUAR_AWARD_AMT_PERCENT CLM_MIN_GUAR_AWARD_AMT_PERCENT
, CLM_MIN_ORDER_AMOUNT CLM_MIN_ORDER_AMOUNT
, CLM_MOD_ISSUING_OFFICE CLM_MOD_ISSUING_OFFICE
, CLM_NO_SIGNED_COPIES_TO_RETURN CLM_NO_SIGNED_COPIES_TO_RETURN
, CLM_PRIORITY_CODE CLM_PRIORITY_CODE
, CLM_SOURCE_DOCUMENT_ID CLM_SOURCE_DOCUMENT_ID
, CLM_STANDARD_FORM CLM_STANDARD_FORM
, CLM_SUPPLIER_NAME CLM_SUPPLIER_NAME
, CLM_SUPPLIER_SITE_NAME CLM_SUPPLIER_SITE_NAME
, CLM_VENDOR_OFFER_NUMBER CLM_VENDOR_OFFER_NUMBER
, COMM_REV_NUM COMM_REV_NUM
, DRAFT_ID DRAFT_ID
, ENABLE_ALL_SITES ENABLE_ALL_SITES
, OTM_RECOVERY_FLAG OTM_RECOVERY_FLAG
, OTM_STATUS_CODE OTM_STATUS_CODE
, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE
, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, UMBRELLA_PROGRAM_ID UMBRELLA_PROGRAM_ID
, FON_REF_ID FON_REF_ID
, CLM_CONTRACT_FINANCE_CODE CLM_CONTRACT_FINANCE_CODE
, CLM_PAYMENT_INSTR_CODE CLM_PAYMENT_INSTR_CODE
, CLM_SPECIAL_CONTRACT_TYPE CLM_SPECIAL_CONTRACT_TYPE
FROM "PO"."PO_HEADERS_ARCHIVE_ALL"