VIEW: APPS.PO_HEADERS_DIFF_V

Source

View Text - Preformatted

SELECT ph_po_header_id pk1_value, draft_id pk2_value, null pk3_value, null pk4_value, null pk5_value, col_name , col_value, revision_num from ( SELECT ph.po_header_id ph_po_header_id, nvl(ph.draft_id,-1) draft_id, ph.org_id, null as change_status, ph.USER_DOCUMENT_STATUS, to_char(ph.SUBMIT_DATE) SUBMIT_DATE, ph.CLM_PAYMENT_INSTR_CODE, ph.SUPPLIER_NOTIF_METHOD, ph.FAX, ph.EMAIL_ADDRESS, ph.RETRO_PRICE_COMM_UPDATES_FLAG, ph.RETRO_PRICE_APPLY_UPDATES_FLAG, ph.UPDATE_SOURCING_RULES_FLAG, ph.AUTO_SOURCING_FLAG, ph.CREATED_LANGUAGE, to_char(ph.CPA_REFERENCE) CPA_REFERENCE, ph.SUPPLIER_AUTH_ENABLED_FLAG, ph.CAT_ADMIN_AUTH_ENABLED_FLAG, to_char(ph.STYLE_ID) STYLE_ID, ph.TAX_ATTRIBUTE_UPDATE_CODE, ph.LAST_UPDATED_PROGRAM, to_char(ph.COMM_REV_NUM) COMM_REV_NUM, ph.CLM_DOCUMENT_NUMBER, ph.OTM_STATUS_CODE, ph.OTM_RECOVERY_FLAG, to_char(ph.UDA_TEMPLATE_ID) UDA_TEMPLATE_ID, ph.ENABLED_FLAG, ph.GLOBAL_ATTRIBUTE20, ph.GLOBAL_AGREEMENT_FLAG, ph.CONSIGNED_CONSUMPTION_FLAG, to_char(ph.CBC_ACCOUNTING_DATE) CBC_ACCOUNTING_DATE, ph.CONSUME_REQ_DEMAND_FLAG, ph.CHANGE_REQUESTED_BY, ph.SHIPPING_CONTROL, ph.CONTERMS_EXIST_FLAG, to_char(ph.CONTERMS_ARTICLES_UPD_DATE) CONTERMS_ARTICLES_UPD_DATE, to_char(ph.CONTERMS_DELIV_UPD_DATE) CONTERMS_DELIV_UPD_DATE, ph.PENDING_SIGNATURE_FLAG, ph.CHANGE_SUMMARY, ph.ENCUMBRANCE_REQUIRED_FLAG, ph.DOCUMENT_CREATION_METHOD, to_char(ph.REPLY_DATE) REPLY_DATE, ph.REPLY_METHOD_LOOKUP_CODE, to_char(ph.RFQ_CLOSE_DATE) RFQ_CLOSE_DATE, ph.QUOTE_TYPE_LOOKUP_CODE, ph.QUOTATION_CLASS_CODE, ph.QUOTE_WARNING_DELAY_UNIT, to_char(ph.QUOTE_WARNING_DELAY) QUOTE_WARNING_DELAY, ph.QUOTE_VENDOR_QUOTE_NUMBER, ph.ACCEPTANCE_REQUIRED_FLAG, to_char(ph.ACCEPTANCE_DUE_DATE) ACCEPTANCE_DUE_DATE, to_char(ph.CLOSED_DATE) CLOSED_DATE, ph.USER_HOLD_FLAG, ph.APPROVAL_REQUIRED_FLAG, ph.CANCEL_FLAG, ph.FIRM_STATUS_LOOKUP_CODE, to_char(ph.FIRM_DATE) FIRM_DATE, ph.FROZEN_FLAG, ph.ATTRIBUTE_CATEGORY, ph.ATTRIBUTE1, ph.ATTRIBUTE2, ph.ATTRIBUTE3, ph.ATTRIBUTE4, ph.ATTRIBUTE5, ph.ATTRIBUTE6, ph.ATTRIBUTE7, ph.ATTRIBUTE8, ph.ATTRIBUTE9, ph.ATTRIBUTE10, ph.ATTRIBUTE11, ph.ATTRIBUTE12, ph.ATTRIBUTE13, ph.ATTRIBUTE14, ph.ATTRIBUTE15, ph.CLOSED_CODE, ph.USSGL_TRANSACTION_CODE, ph.GOVERNMENT_CONTEXT, to_char(ph.REQUEST_ID) REQUEST_ID, to_char(ph.PROGRAM_APPLICATION_ID) PROGRAM_APPLICATION_ID, to_char(ph.PROGRAM_ID) PROGRAM_ID, to_char(ph.PROGRAM_UPDATE_DATE) PROGRAM_UPDATE_DATE, ph.SUPPLY_AGREEMENT_FLAG, ph.EDI_PROCESSED_FLAG, ph.EDI_PROCESSED_STATUS, ph.GLOBAL_ATTRIBUTE_CATEGORY, ph.GLOBAL_ATTRIBUTE1, ph.GLOBAL_ATTRIBUTE2, ph.GLOBAL_ATTRIBUTE3, ph.GLOBAL_ATTRIBUTE4, ph.GLOBAL_ATTRIBUTE5, ph.GLOBAL_ATTRIBUTE6, ph.GLOBAL_ATTRIBUTE7, ph.GLOBAL_ATTRIBUTE8, ph.GLOBAL_ATTRIBUTE9, ph.GLOBAL_ATTRIBUTE10, ph.GLOBAL_ATTRIBUTE11, ph.GLOBAL_ATTRIBUTE12, ph.GLOBAL_ATTRIBUTE13, ph.GLOBAL_ATTRIBUTE14, ph.GLOBAL_ATTRIBUTE15, ph.GLOBAL_ATTRIBUTE16, ph.GLOBAL_ATTRIBUTE17, ph.GLOBAL_ATTRIBUTE18, ph.GLOBAL_ATTRIBUTE19, ph.INTERFACE_SOURCE_CODE, ph.REFERENCE_NUM, ph.MRC_RATE_TYPE, ph.MRC_RATE_DATE, ph.MRC_RATE, to_char(ph.PCARD_ID) PCARD_ID, to_char(ph.PRICE_UPDATE_TOLERANCE) PRICE_UPDATE_TOLERANCE, ph.PAY_ON_CODE, ph.XML_FLAG, to_char(ph.XML_SEND_DATE) XML_SEND_DATE, to_char(ph.XML_CHANGE_SEND_DATE) XML_CHANGE_SEND_DATE, to_char(ph.CLM_EFFECTIVE_DATE) CLM_EFFECTIVE_DATE, ph.CLM_VENDOR_OFFER_NUMBER, ph.CLM_AWARD_ADMINISTRATOR, to_char(ph.CLM_NO_SIGNED_COPIES_TO_RETURN) CLM_NO_SIGNED_COPIES_TO_RETURN, to_char(ph.CLM_MIN_GUARANTEE_AWARD_AMT) CLM_MIN_GUARANTEE_AWARD_AMT, to_char(ph.CLM_MIN_GUAR_AWARD_AMT_PERCENT) CLM_MIN_GUAR_AWARD_AMT_PERCENT, to_char(ph.CLM_MIN_ORDER_AMOUNT) CLM_MIN_ORDER_AMOUNT, to_char(ph.CLM_MAX_ORDER_AMOUNT) CLM_MAX_ORDER_AMOUNT, ph.CLM_AMT_SYNCED_TO_AGREEMENT, to_char(ph.CLM_AMOUNT_RELEASED) CLM_AMOUNT_RELEASED, ph.CLM_EXTERNAL_IDV, ph.CLM_SUPPLIER_NAME, ph.CLM_SUPPLIER_SITE_NAME, to_char(ph.CLM_SOURCE_DOCUMENT_ID) CLM_SOURCE_DOCUMENT_ID, ph.CLM_ISSUING_OFFICE, ph.CLM_COTR_OFFICE, ph.CLM_COTR_CONTACT, ph.CLM_PRIORITY_CODE, ph.CLM_MOD_ISSUING_OFFICE, ph.CLM_STANDARD_FORM, ph.CLM_DOCUMENT_FORMAT, ph.CLM_AWARD_TYPE, to_char(ph.CLM_CONTRACT_OFFICER) CLM_CONTRACT_OFFICER, ph.CLM_CLOSEOUT_STATUS, to_char(ph.UMBRELLA_PROGRAM_ID) UMBRELLA_PROGRAM_ID, to_char(ph.FON_REF_ID) FON_REF_ID, ph.ENABLE_ALL_SITES, ph.CLM_CONTRACT_FINANCE_CODE, ph.CLM_SPECIAL_CONTRACT_TYPE, ph.PAY_WHEN_PAID, to_char(ph.UDA_TEMPLATE_DATE) UDA_TEMPLATE_DATE, to_char(ph.AGENT_ID) AGENT_ID, ph.TYPE_LOOKUP_CODE, ph.SEGMENT1, ph.SUMMARY_FLAG, ph.SEGMENT2, ph.SEGMENT3, ph.SEGMENT4, ph.SEGMENT5, to_char(ph.START_DATE_ACTIVE) START_DATE_ACTIVE, to_char(ph.END_DATE_ACTIVE) END_DATE_ACTIVE, to_char(ph.VENDOR_ID) VENDOR_ID, to_char(ph.VENDOR_SITE_ID) VENDOR_SITE_ID, to_char(ph.VENDOR_CONTACT_ID) VENDOR_CONTACT_ID, to_char(ph.SHIP_TO_LOCATION_ID) SHIP_TO_LOCATION_ID, to_char(ph.BILL_TO_LOCATION_ID) BILL_TO_LOCATION_ID, to_char(ph.TERMS_ID) TERMS_ID, ph.SHIP_VIA_LOOKUP_CODE, ph.FOB_LOOKUP_CODE, ph.FREIGHT_TERMS_LOOKUP_CODE, ph.STATUS_LOOKUP_CODE, ph.CURRENCY_CODE, ph.RATE_TYPE, to_char(ph.RATE_DATE) RATE_DATE, to_char(ph.RATE) RATE, to_char(ph.FROM_HEADER_ID) FROM_HEADER_ID, ph.FROM_TYPE_LOOKUP_CODE, to_char(ph.START_DATE) START_DATE, to_char(ph.END_DATE) END_DATE, to_char(ph.BLANKET_TOTAL_AMOUNT) BLANKET_TOTAL_AMOUNT, ph.AUTHORIZATION_STATUS, to_char(ph.REVISION_NUM) REVISION_NUM, to_char(ph.REVISED_DATE) REVISED_DATE, ph.APPROVED_FLAG, to_char(ph.APPROVED_DATE) APPROVED_DATE, to_char(ph.AMOUNT_LIMIT) AMOUNT_LIMIT, to_char(ph.MIN_RELEASE_AMOUNT) MIN_RELEASE_AMOUNT, ph.NOTE_TO_AUTHORIZER, ph.NOTE_TO_VENDOR, ph.NOTE_TO_RECEIVER, to_char(ph.PRINT_COUNT) PRINT_COUNT, to_char(ph.PRINTED_DATE) PRINTED_DATE, ph.VENDOR_ORDER_NUM, ph.CONFIRMING_ORDER_FLAG, ph.COMMENTS FROM po_headers_archive_all ph WHERE po_header_id = PO_GEN_DIFF_PKG.getBasePK1 AND Nvl(draft_id,-1) = -1 ) po_header_unpivot_data unpivot include nulls ( col_value for col_name in ( CHANGE_STATUS, USER_DOCUMENT_STATUS, SUBMIT_DATE, CLM_PAYMENT_INSTR_CODE, 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, TAX_ATTRIBUTE_UPDATE_CODE, LAST_UPDATED_PROGRAM, COMM_REV_NUM, CLM_DOCUMENT_NUMBER, OTM_STATUS_CODE, OTM_RECOVERY_FLAG, UDA_TEMPLATE_ID, ENABLED_FLAG, GLOBAL_ATTRIBUTE20, GLOBAL_AGREEMENT_FLAG, CONSIGNED_CONSUMPTION_FLAG, CBC_ACCOUNTING_DATE, CONSUME_REQ_DEMAND_FLAG, CHANGE_REQUESTED_BY, SHIPPING_CONTROL, CONTERMS_EXIST_FLAG, CONTERMS_ARTICLES_UPD_DATE, CONTERMS_DELIV_UPD_DATE, PENDING_SIGNATURE_FLAG, CHANGE_SUMMARY, ENCUMBRANCE_REQUIRED_FLAG, DOCUMENT_CREATION_METHOD, 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, APPROVAL_REQUIRED_FLAG, CANCEL_FLAG, FIRM_STATUS_LOOKUP_CODE, FIRM_DATE, FROZEN_FLAG, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, CLOSED_CODE, USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, SUPPLY_AGREEMENT_FLAG, EDI_PROCESSED_FLAG, EDI_PROCESSED_STATUS, 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, INTERFACE_SOURCE_CODE, REFERENCE_NUM, MRC_RATE_TYPE, MRC_RATE_DATE, MRC_RATE, PCARD_ID, PRICE_UPDATE_TOLERANCE, PAY_ON_CODE, XML_FLAG, XML_SEND_DATE, XML_CHANGE_SEND_DATE, CLM_EFFECTIVE_DATE, CLM_VENDOR_OFFER_NUMBER, CLM_AWARD_ADMINISTRATOR, CLM_NO_SIGNED_COPIES_TO_RETURN, CLM_MIN_GUARANTEE_AWARD_AMT, CLM_MIN_GUAR_AWARD_AMT_PERCENT, CLM_MIN_ORDER_AMOUNT, CLM_MAX_ORDER_AMOUNT, CLM_AMT_SYNCED_TO_AGREEMENT, CLM_AMOUNT_RELEASED, CLM_EXTERNAL_IDV, CLM_SUPPLIER_NAME, CLM_SUPPLIER_SITE_NAME, CLM_SOURCE_DOCUMENT_ID, CLM_ISSUING_OFFICE, CLM_COTR_OFFICE, CLM_COTR_CONTACT, CLM_PRIORITY_CODE, CLM_MOD_ISSUING_OFFICE, CLM_STANDARD_FORM, CLM_DOCUMENT_FORMAT, CLM_AWARD_TYPE, CLM_CONTRACT_OFFICER, CLM_CLOSEOUT_STATUS, UMBRELLA_PROGRAM_ID, FON_REF_ID, ENABLE_ALL_SITES, CLM_CONTRACT_FINANCE_CODE, CLM_SPECIAL_CONTRACT_TYPE, PAY_WHEN_PAID, UDA_TEMPLATE_DATE, AGENT_ID, TYPE_LOOKUP_CODE, SEGMENT1, SUMMARY_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, 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) )

View Text - HTML Formatted

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