VIEW: PO.PO_HEADERS_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, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG, CANCEL_FLAG CANCEL_FLAG, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE, FIRM_DATE FIRM_DATE, FROZEN_FLAG FROZEN_FLAG, SUPPLY_AGREEMENT_FLAG SUPPLY_AGREEMENT_FLAG, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG, EDI_PROCESSED_STATUS EDI_PROCESSED_STATUS, 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, CLOSED_CODE CLOSED_CODE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, 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, 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, PCARD_ID PCARD_ID, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE, 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, SHIPPING_CONTROL SHIPPING_CONTROL, CONTERMS_EXIST_FLAG CONTERMS_EXIST_FLAG, CONTERMS_ARTICLES_UPD_DATE CONTERMS_ARTICLES_UPD_DATE, CONTERMS_DELIV_UPD_DATE CONTERMS_DELIV_UPD_DATE, ENCUMBRANCE_REQUIRED_FLAG ENCUMBRANCE_REQUIRED_FLAG, 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, LOCK_OWNER_ROLE LOCK_OWNER_ROLE, LOCK_OWNER_USER_ID LOCK_OWNER_USER_ID, SUPPLIER_AUTH_ENABLED_FLAG SUPPLIER_AUTH_ENABLED_FLAG, CAT_ADMIN_AUTH_ENABLED_FLAG CAT_ADMIN_AUTH_ENABLED_FLAG, STYLE_ID STYLE_ID, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE, LAST_UPDATED_PROGRAM LAST_UPDATED_PROGRAM, ENABLE_ALL_SITES ENABLE_ALL_SITES, PAY_WHEN_PAID PAY_WHEN_PAID, COMM_REV_NUM COMM_REV_NUM, CLM_DOCUMENT_NUMBER CLM_DOCUMENT_NUMBER, OTM_STATUS_CODE OTM_STATUS_CODE, OTM_RECOVERY_FLAG OTM_RECOVERY_FLAG, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE, USER_DOCUMENT_STATUS USER_DOCUMENT_STATUS, AME_APPROVAL_ID AME_APPROVAL_ID, DRAFT_ID DRAFT_ID, CLM_EFFECTIVE_DATE CLM_EFFECTIVE_DATE, CLM_VENDOR_OFFER_NUMBER CLM_VENDOR_OFFER_NUMBER, CLM_AWARD_ADMINISTRATOR CLM_AWARD_ADMINISTRATOR, CLM_NO_SIGNED_COPIES_TO_RETURN CLM_NO_SIGNED_COPIES_TO_RETURN, 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_MAX_ORDER_AMOUNT CLM_MAX_ORDER_AMOUNT, CLM_AMT_SYNCED_TO_AGREEMENT CLM_AMT_SYNCED_TO_AGREEMENT, CLM_AMOUNT_RELEASED CLM_AMOUNT_RELEASED, CLM_EXTERNAL_IDV CLM_EXTERNAL_IDV, CLM_SUPPLIER_NAME CLM_SUPPLIER_NAME, CLM_SUPPLIER_SITE_NAME CLM_SUPPLIER_SITE_NAME, CLM_SOURCE_DOCUMENT_ID CLM_SOURCE_DOCUMENT_ID, CLM_ISSUING_OFFICE CLM_ISSUING_OFFICE, CLM_COTR_OFFICE CLM_COTR_OFFICE, CLM_COTR_CONTACT CLM_COTR_CONTACT, CLM_PRIORITY_CODE CLM_PRIORITY_CODE, CLM_MOD_ISSUING_OFFICE CLM_MOD_ISSUING_OFFICE, CLM_STANDARD_FORM CLM_STANDARD_FORM, CLM_DOCUMENT_FORMAT CLM_DOCUMENT_FORMAT, AME_TRANSACTION_TYPE AME_TRANSACTION_TYPE, CLM_AWARD_TYPE CLM_AWARD_TYPE, CLM_CONTRACT_OFFICER CLM_CONTRACT_OFFICER, CLM_CLOSEOUT_STATUS CLM_CLOSEOUT_STATUS, UMBRELLA_PROGRAM_ID UMBRELLA_PROGRAM_ID, FON_REF_ID FON_REF_ID, CLM_DEFAULT_DIST_FLAG CLM_DEFAULT_DIST_FLAG, CLM_EDAGEN_DATE CLM_EDAGEN_DATE, 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_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
, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG
, CANCEL_FLAG CANCEL_FLAG
, FIRM_STATUS_LOOKUP_CODE FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE FIRM_DATE
, FROZEN_FLAG FROZEN_FLAG
, SUPPLY_AGREEMENT_FLAG SUPPLY_AGREEMENT_FLAG
, EDI_PROCESSED_FLAG EDI_PROCESSED_FLAG
, EDI_PROCESSED_STATUS EDI_PROCESSED_STATUS
, 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
, CLOSED_CODE CLOSED_CODE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, 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
, 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
, PCARD_ID PCARD_ID
, PRICE_UPDATE_TOLERANCE PRICE_UPDATE_TOLERANCE
, 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
, SHIPPING_CONTROL SHIPPING_CONTROL
, CONTERMS_EXIST_FLAG CONTERMS_EXIST_FLAG
, CONTERMS_ARTICLES_UPD_DATE CONTERMS_ARTICLES_UPD_DATE
, CONTERMS_DELIV_UPD_DATE CONTERMS_DELIV_UPD_DATE
, ENCUMBRANCE_REQUIRED_FLAG ENCUMBRANCE_REQUIRED_FLAG
, 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
, LOCK_OWNER_ROLE LOCK_OWNER_ROLE
, LOCK_OWNER_USER_ID LOCK_OWNER_USER_ID
, SUPPLIER_AUTH_ENABLED_FLAG SUPPLIER_AUTH_ENABLED_FLAG
, CAT_ADMIN_AUTH_ENABLED_FLAG CAT_ADMIN_AUTH_ENABLED_FLAG
, STYLE_ID STYLE_ID
, TAX_ATTRIBUTE_UPDATE_CODE TAX_ATTRIBUTE_UPDATE_CODE
, LAST_UPDATED_PROGRAM LAST_UPDATED_PROGRAM
, ENABLE_ALL_SITES ENABLE_ALL_SITES
, PAY_WHEN_PAID PAY_WHEN_PAID
, COMM_REV_NUM COMM_REV_NUM
, CLM_DOCUMENT_NUMBER CLM_DOCUMENT_NUMBER
, OTM_STATUS_CODE OTM_STATUS_CODE
, OTM_RECOVERY_FLAG OTM_RECOVERY_FLAG
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE
, USER_DOCUMENT_STATUS USER_DOCUMENT_STATUS
, AME_APPROVAL_ID AME_APPROVAL_ID
, DRAFT_ID DRAFT_ID
, CLM_EFFECTIVE_DATE CLM_EFFECTIVE_DATE
, CLM_VENDOR_OFFER_NUMBER CLM_VENDOR_OFFER_NUMBER
, CLM_AWARD_ADMINISTRATOR CLM_AWARD_ADMINISTRATOR
, CLM_NO_SIGNED_COPIES_TO_RETURN CLM_NO_SIGNED_COPIES_TO_RETURN
, 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_MAX_ORDER_AMOUNT CLM_MAX_ORDER_AMOUNT
, CLM_AMT_SYNCED_TO_AGREEMENT CLM_AMT_SYNCED_TO_AGREEMENT
, CLM_AMOUNT_RELEASED CLM_AMOUNT_RELEASED
, CLM_EXTERNAL_IDV CLM_EXTERNAL_IDV
, CLM_SUPPLIER_NAME CLM_SUPPLIER_NAME
, CLM_SUPPLIER_SITE_NAME CLM_SUPPLIER_SITE_NAME
, CLM_SOURCE_DOCUMENT_ID CLM_SOURCE_DOCUMENT_ID
, CLM_ISSUING_OFFICE CLM_ISSUING_OFFICE
, CLM_COTR_OFFICE CLM_COTR_OFFICE
, CLM_COTR_CONTACT CLM_COTR_CONTACT
, CLM_PRIORITY_CODE CLM_PRIORITY_CODE
, CLM_MOD_ISSUING_OFFICE CLM_MOD_ISSUING_OFFICE
, CLM_STANDARD_FORM CLM_STANDARD_FORM
, CLM_DOCUMENT_FORMAT CLM_DOCUMENT_FORMAT
, AME_TRANSACTION_TYPE AME_TRANSACTION_TYPE
, CLM_AWARD_TYPE CLM_AWARD_TYPE
, CLM_CONTRACT_OFFICER CLM_CONTRACT_OFFICER
, CLM_CLOSEOUT_STATUS CLM_CLOSEOUT_STATUS
, UMBRELLA_PROGRAM_ID UMBRELLA_PROGRAM_ID
, FON_REF_ID FON_REF_ID
, CLM_DEFAULT_DIST_FLAG CLM_DEFAULT_DIST_FLAG
, CLM_EDAGEN_DATE CLM_EDAGEN_DATE
, 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_ALL"