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