VIEW: APPS.PO_HEADER_CHANGES_V

Source

View Text - Preformatted

SELECT "MOD_DOC_PK1_VAL", "MOD_DOC_PK2_VAL", "ENTITY_NAME", "AGENT_ID", "TYPE_LOOKUP_CODE", "SEGMENT1", "SUMMARY_FLAG", "ENABLED_FLAG", "SEGMENT2", "SEGMENT3", "SEGMENT4", "SEGMENT5", "START_DATE_ACTIVE", "END_DATE_ACTIVE", "VENDOR_ID", "VENDOR_SITE_ID", "VENDOR_CONTACT_ID", "SHIP_TO_LOCATION_ID", "BILL_TO_LOCATION_ID", "TERMS_ID", "SHIP_VIA_LOOKUP_CODE", "FOB_LOOKUP_CODE", "FREIGHT_TERMS_LOOKUP_CODE", "STATUS_LOOKUP_CODE", "CURRENCY_CODE", "RATE_TYPE", "RATE_DATE", "RATE", "FROM_HEADER_ID", "FROM_TYPE_LOOKUP_CODE", "START_DATE", "END_DATE", "BLANKET_TOTAL_AMOUNT", "AUTHORIZATION_STATUS", "REVISION_NUM", "REVISED_DATE", "APPROVED_FLAG", "APPROVED_DATE", "AMOUNT_LIMIT", "MIN_RELEASE_AMOUNT", "NOTE_TO_AUTHORIZER", "NOTE_TO_VENDOR", "NOTE_TO_RECEIVER", "PRINT_COUNT", "PRINTED_DATE", "VENDOR_ORDER_NUM", "CONFIRMING_ORDER_FLAG", "COMMENTS", "REPLY_DATE", "REPLY_METHOD_LOOKUP_CODE", "RFQ_CLOSE_DATE", "QUOTE_TYPE_LOOKUP_CODE", "QUOTATION_CLASS_CODE", "QUOTE_WARNING_DELAY_UNIT", "QUOTE_WARNING_DELAY", "QUOTE_VENDOR_QUOTE_NUMBER", "ACCEPTANCE_REQUIRED_FLAG", "ACCEPTANCE_DUE_DATE", "CLOSED_DATE", "USER_HOLD_FLAG", "EVER_APPROVED_FLAG", "APPROVAL_REQUIRED_FLAG", "CANCEL_FLAG", "STANDARD_COMMENT_CODE", "FIRM_STATUS_LOOKUP_CODE", "FIRM_DATE", "FROZEN_FLAG", "ATTRIBUTE_CATEGORY", "ATTRIBUTE1", "ATTRIBUTE2", "ATTRIBUTE3", "ATTRIBUTE4", "ATTRIBUTE5", "ATTRIBUTE6", "CLOSED_CODE", "USSGL_TRANSACTION_CODE", "GOVERNMENT_CONTEXT", "ATTRIBUTE7", "ATTRIBUTE8", "ATTRIBUTE9", "ATTRIBUTE10", "ATTRIBUTE11", "ATTRIBUTE12", "ATTRIBUTE13", "ATTRIBUTE14", "ATTRIBUTE15", "LATEST_EXTERNAL_FLAG", "REQUEST_ID", "PROGRAM_APPLICATION_ID", "PROGRAM_ID", "PROGRAM_UPDATE_DATE", "ORG_ID", "EDI_PROCESSED_FLAG", "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", "PCARD_ID", "PRICE_UPDATE_TOLERANCE", "SUPPLY_AGREEMENT_FLAG", "EDI_PROCESSED_STATUS", "INTERFACE_SOURCE_CODE", "REFERENCE_NUM", "WF_ITEM_TYPE", "WF_ITEM_KEY", "MRC_RATE_TYPE", "MRC_RATE_DATE", "MRC_RATE", "PAY_ON_CODE", "XML_FLAG", "XML_SEND_DATE", "XML_CHANGE_SEND_DATE", "GLOBAL_AGREEMENT_FLAG", "CONSIGNED_CONSUMPTION_FLAG", "CBC_ACCOUNTING_DATE", "CONSUME_REQ_DEMAND_FLAG", "CHANGE_REQUESTED_BY", "CONTERMS_EXIST_FLAG", "CONTERMS_ARTICLES_UPD_DATE", "ENCUMBRANCE_REQUIRED_FLAG", "CONTERMS_DELIV_UPD_DATE", "SHIPPING_CONTROL", "PENDING_SIGNATURE_FLAG", "CHANGE_SUMMARY", "DOCUMENT_CREATION_METHOD", "SUBMIT_DATE", "SUPPLIER_NOTIF_METHOD", "FAX", "EMAIL_ADDRESS", "RETRO_PRICE_COMM_UPDATES_FLAG", "RETRO_PRICE_APPLY_UPDATES_FLAG", "UPDATE_SOURCING_RULES_FLAG", "AUTO_SOURCING_FLAG", "CREATED_LANGUAGE", "CPA_REFERENCE", "SUPPLIER_AUTH_ENABLED_FLAG", "CAT_ADMIN_AUTH_ENABLED_FLAG", "STYLE_ID", "LAST_UPDATED_PROGRAM", "PAY_WHEN_PAID", "USER_DOCUMENT_STATUS", "AME_APPROVAL_ID", "CLM_DOCUMENT_NUMBER", "AME_TRANSACTION_TYPE", "CLM_AMOUNT_RELEASED", "CLM_AMT_SYNCED_TO_AGREEMENT", "CLM_AWARD_ADMINISTRATOR", "CLM_AWARD_TYPE", "CLM_CLOSEOUT_STATUS", "CLM_CONTRACT_OFFICER", "CLM_COTR_CONTACT", "CLM_COTR_OFFICE", "CLM_DOCUMENT_FORMAT", "CLM_EFFECTIVE_DATE", "CLM_EXTERNAL_IDV", "CLM_ISSUING_OFFICE", "CLM_MAX_ORDER_AMOUNT", "CLM_MIN_GUARANTEE_AWARD_AMT", "CLM_MIN_GUAR_AWARD_AMT_PERCENT", "CLM_MIN_ORDER_AMOUNT", "CLM_MOD_ISSUING_OFFICE", "CLM_NO_SIGNED_COPIES_TO_RETURN", "CLM_PRIORITY_CODE", "CLM_SOURCE_DOCUMENT_ID", "CLM_STANDARD_FORM", "CLM_SUPPLIER_NAME", "CLM_SUPPLIER_SITE_NAME", "CLM_VENDOR_OFFER_NUMBER", "COMM_REV_NUM", "ENABLE_ALL_SITES", "ENCUMBRANCE_REQUIRED", "OTM_RECOVERY_FLAG", "OTM_STATUS_CODE", "TAX_ATTRIBUTE_UPDATE_CODE", "UDA_TEMPLATE_DATE", "UDA_TEMPLATE_ID", "UMBRELLA_PROGRAM_ID", "FON_REF_ID", "CLM_CONTRACT_FINANCE_CODE", "CLM_SPECIAL_CONTRACT_TYPE", "CLM_PAYMENT_INSTR_CODE", "CHANGE_STATUS" FROM (SELECT MOD_DOC_PK1_VAL,MOD_DOC_PK2_VAL,entity_name, column_name,mod_value FROM PO_ENTITY_DIFFERENCES WHERE entity_name = 'HEADER' AND MOD_DOC_SOURCE_NAME = 'PO_HEADERS_DRAFT_DIFF_V') pivot(Max(mod_value) FOR column_name IN ( 'AGENT_ID' AGENT_ID, 'TYPE_LOOKUP_CODE' TYPE_LOOKUP_CODE, '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, '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, 'EDI_PROCESSED_FLAG' EDI_PROCESSED_FLAG, '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, '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, 'ENABLE_ALL_SITES' ENABLE_ALL_SITES, 'ENCUMBRANCE_REQUIRED' ENCUMBRANCE_REQUIRED, '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_SPECIAL_CONTRACT_TYPE' CLM_SPECIAL_CONTRACT_TYPE, 'CLM_PAYMENT_INSTR_CODE' CLM_PAYMENT_INSTR_CODE, 'CHANGE_STATUS' CHANGE_STATUS))

View Text - HTML Formatted

SELECT "MOD_DOC_PK1_VAL"
, "MOD_DOC_PK2_VAL"
, "ENTITY_NAME"
, "AGENT_ID"
, "TYPE_LOOKUP_CODE"
, "SEGMENT1"
, "SUMMARY_FLAG"
, "ENABLED_FLAG"
, "SEGMENT2"
, "SEGMENT3"
, "SEGMENT4"
, "SEGMENT5"
, "START_DATE_ACTIVE"
, "END_DATE_ACTIVE"
, "VENDOR_ID"
, "VENDOR_SITE_ID"
, "VENDOR_CONTACT_ID"
, "SHIP_TO_LOCATION_ID"
, "BILL_TO_LOCATION_ID"
, "TERMS_ID"
, "SHIP_VIA_LOOKUP_CODE"
, "FOB_LOOKUP_CODE"
, "FREIGHT_TERMS_LOOKUP_CODE"
, "STATUS_LOOKUP_CODE"
, "CURRENCY_CODE"
, "RATE_TYPE"
, "RATE_DATE"
, "RATE"
, "FROM_HEADER_ID"
, "FROM_TYPE_LOOKUP_CODE"
, "START_DATE"
, "END_DATE"
, "BLANKET_TOTAL_AMOUNT"
, "AUTHORIZATION_STATUS"
, "REVISION_NUM"
, "REVISED_DATE"
, "APPROVED_FLAG"
, "APPROVED_DATE"
, "AMOUNT_LIMIT"
, "MIN_RELEASE_AMOUNT"
, "NOTE_TO_AUTHORIZER"
, "NOTE_TO_VENDOR"
, "NOTE_TO_RECEIVER"
, "PRINT_COUNT"
, "PRINTED_DATE"
, "VENDOR_ORDER_NUM"
, "CONFIRMING_ORDER_FLAG"
, "COMMENTS"
, "REPLY_DATE"
, "REPLY_METHOD_LOOKUP_CODE"
, "RFQ_CLOSE_DATE"
, "QUOTE_TYPE_LOOKUP_CODE"
, "QUOTATION_CLASS_CODE"
, "QUOTE_WARNING_DELAY_UNIT"
, "QUOTE_WARNING_DELAY"
, "QUOTE_VENDOR_QUOTE_NUMBER"
, "ACCEPTANCE_REQUIRED_FLAG"
, "ACCEPTANCE_DUE_DATE"
, "CLOSED_DATE"
, "USER_HOLD_FLAG"
, "EVER_APPROVED_FLAG"
, "APPROVAL_REQUIRED_FLAG"
, "CANCEL_FLAG"
, "STANDARD_COMMENT_CODE"
, "FIRM_STATUS_LOOKUP_CODE"
, "FIRM_DATE"
, "FROZEN_FLAG"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "CLOSED_CODE"
, "USSGL_TRANSACTION_CODE"
, "GOVERNMENT_CONTEXT"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "LATEST_EXTERNAL_FLAG"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "ORG_ID"
, "EDI_PROCESSED_FLAG"
, "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"
, "PCARD_ID"
, "PRICE_UPDATE_TOLERANCE"
, "SUPPLY_AGREEMENT_FLAG"
, "EDI_PROCESSED_STATUS"
, "INTERFACE_SOURCE_CODE"
, "REFERENCE_NUM"
, "WF_ITEM_TYPE"
, "WF_ITEM_KEY"
, "MRC_RATE_TYPE"
, "MRC_RATE_DATE"
, "MRC_RATE"
, "PAY_ON_CODE"
, "XML_FLAG"
, "XML_SEND_DATE"
, "XML_CHANGE_SEND_DATE"
, "GLOBAL_AGREEMENT_FLAG"
, "CONSIGNED_CONSUMPTION_FLAG"
, "CBC_ACCOUNTING_DATE"
, "CONSUME_REQ_DEMAND_FLAG"
, "CHANGE_REQUESTED_BY"
, "CONTERMS_EXIST_FLAG"
, "CONTERMS_ARTICLES_UPD_DATE"
, "ENCUMBRANCE_REQUIRED_FLAG"
, "CONTERMS_DELIV_UPD_DATE"
, "SHIPPING_CONTROL"
, "PENDING_SIGNATURE_FLAG"
, "CHANGE_SUMMARY"
, "DOCUMENT_CREATION_METHOD"
, "SUBMIT_DATE"
, "SUPPLIER_NOTIF_METHOD"
, "FAX"
, "EMAIL_ADDRESS"
, "RETRO_PRICE_COMM_UPDATES_FLAG"
, "RETRO_PRICE_APPLY_UPDATES_FLAG"
, "UPDATE_SOURCING_RULES_FLAG"
, "AUTO_SOURCING_FLAG"
, "CREATED_LANGUAGE"
, "CPA_REFERENCE"
, "SUPPLIER_AUTH_ENABLED_FLAG"
, "CAT_ADMIN_AUTH_ENABLED_FLAG"
, "STYLE_ID"
, "LAST_UPDATED_PROGRAM"
, "PAY_WHEN_PAID"
, "USER_DOCUMENT_STATUS"
, "AME_APPROVAL_ID"
, "CLM_DOCUMENT_NUMBER"
, "AME_TRANSACTION_TYPE"
, "CLM_AMOUNT_RELEASED"
, "CLM_AMT_SYNCED_TO_AGREEMENT"
, "CLM_AWARD_ADMINISTRATOR"
, "CLM_AWARD_TYPE"
, "CLM_CLOSEOUT_STATUS"
, "CLM_CONTRACT_OFFICER"
, "CLM_COTR_CONTACT"
, "CLM_COTR_OFFICE"
, "CLM_DOCUMENT_FORMAT"
, "CLM_EFFECTIVE_DATE"
, "CLM_EXTERNAL_IDV"
, "CLM_ISSUING_OFFICE"
, "CLM_MAX_ORDER_AMOUNT"
, "CLM_MIN_GUARANTEE_AWARD_AMT"
, "CLM_MIN_GUAR_AWARD_AMT_PERCENT"
, "CLM_MIN_ORDER_AMOUNT"
, "CLM_MOD_ISSUING_OFFICE"
, "CLM_NO_SIGNED_COPIES_TO_RETURN"
, "CLM_PRIORITY_CODE"
, "CLM_SOURCE_DOCUMENT_ID"
, "CLM_STANDARD_FORM"
, "CLM_SUPPLIER_NAME"
, "CLM_SUPPLIER_SITE_NAME"
, "CLM_VENDOR_OFFER_NUMBER"
, "COMM_REV_NUM"
, "ENABLE_ALL_SITES"
, "ENCUMBRANCE_REQUIRED"
, "OTM_RECOVERY_FLAG"
, "OTM_STATUS_CODE"
, "TAX_ATTRIBUTE_UPDATE_CODE"
, "UDA_TEMPLATE_DATE"
, "UDA_TEMPLATE_ID"
, "UMBRELLA_PROGRAM_ID"
, "FON_REF_ID"
, "CLM_CONTRACT_FINANCE_CODE"
, "CLM_SPECIAL_CONTRACT_TYPE"
, "CLM_PAYMENT_INSTR_CODE"
, "CHANGE_STATUS"
FROM (SELECT MOD_DOC_PK1_VAL
, MOD_DOC_PK2_VAL
, ENTITY_NAME
, COLUMN_NAME
, MOD_VALUE
FROM PO_ENTITY_DIFFERENCES
WHERE ENTITY_NAME = 'HEADER'
AND MOD_DOC_SOURCE_NAME = 'PO_HEADERS_DRAFT_DIFF_V') PIVOT(MAX(MOD_VALUE) FOR COLUMN_NAME IN ( 'AGENT_ID' AGENT_ID
, 'TYPE_LOOKUP_CODE' TYPE_LOOKUP_CODE
, '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
, '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
, 'EDI_PROCESSED_FLAG' EDI_PROCESSED_FLAG
, '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
, '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
, 'ENABLE_ALL_SITES' ENABLE_ALL_SITES
, 'ENCUMBRANCE_REQUIRED' ENCUMBRANCE_REQUIRED
, '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_SPECIAL_CONTRACT_TYPE' CLM_SPECIAL_CONTRACT_TYPE
, 'CLM_PAYMENT_INSTR_CODE' CLM_PAYMENT_INSTR_CODE
, 'CHANGE_STATUS' CHANGE_STATUS))