VIEW: APPS.PO_HEADERS_MERGE_V

Source

View Text - Preformatted

SELECT Dft.Owner_User_Id, Dft.Owner_Role, Dft.Status, Dft.Draft_Id, Phda.Change_Accepted_Flag, Phda.Delete_Flag, Phda.Email_Address, Phda.Fax, Phda.Supplier_Notif_Method, Phda.Auto_Sourcing_Flag, Phda.Update_Sourcing_Rules_Flag, Phda.Retro_Price_Apply_Updates_Flag, Phda.Retro_Price_Comm_Updates_Flag, Phda.Closed_Code, Phda.Ussgl_Transaction_Code, Phda.Government_Context, Phda.Request_Id, Phda.Program_Application_Id, Phda.Program_Id, Phda.Program_Update_Date, Phda.Org_Id, Phda.Comments, Phda.Reply_Date, Phda.Reply_Method_Lookup_Code, Phda.Rfq_Close_Date, Phda.Quote_Type_Lookup_Code, Phda.Quotation_Class_Code, Phda.Quote_Warning_Delay_Unit, Phda.Quote_Warning_Delay, Phda.Quote_Vendor_Quote_Number, Phda.Acceptance_Required_Flag, Phda.Acceptance_Due_Date, Phda.Closed_Date, Phda.User_Hold_Flag, Phda.Approval_Required_Flag, Phda.Cancel_Flag, Phda.Firm_Status_Lookup_Code, Phda.Firm_Date, Phda.Frozen_Flag, Phda.Edi_Processed_Flag, Phda.Edi_Processed_Status, Phda.Attribute_Category, Phda.Attribute1, Phda.Attribute2, Phda.Attribute3, Phda.Attribute4, Phda.Attribute5, Phda.Attribute6, Phda.Attribute7, Phda.Attribute8, Phda.Attribute9, Phda.Attribute10, Phda.Attribute11, Phda.Attribute12, Phda.Attribute13, Phda.Attribute14, Phda.Attribute15, Phda.Created_By, Phda.Vendor_Id, Phda.Vendor_Site_Id, Phda.Vendor_Contact_Id, Phda.Ship_To_Location_Id, Phda.Bill_To_Location_Id, Phda.Terms_Id, Phda.Ship_Via_Lookup_Code, Phda.Fob_Lookup_Code, Phda.Freight_Terms_Lookup_Code, Phda.Status_Lookup_Code, Phda.Currency_Code, Phda.Rate_Type, Phda.Rate_Date, Phda.Rate, Phda.From_Header_Id, Phda.From_Type_Lookup_Code, Phda.Start_Date, Phda.End_Date, Phda.Blanket_Total_Amount, Phda.Authorization_Status, Phda.Revision_Num, Phda.Revised_Date, Phda.Approved_Flag, Phda.Approved_Date, Phda.Amount_Limit, Phda.Min_Release_Amount, Phda.Note_To_Authorizer, Phda.Note_To_Vendor, Phda.Note_To_Receiver, Phda.Print_Count, Phda.Printed_Date, Phda.Vendor_Order_Num, Phda.Confirming_Order_Flag, Phda.Po_Header_Id, Phda.Agent_Id, Phda.Type_Lookup_Code, Phda.Last_Update_Date, Phda.Last_Updated_By, Phda.Segment1, Phda.Summary_Flag, Phda.Enabled_Flag, Phda.Segment2, Phda.Segment3, Phda.Segment4, Phda.Segment5, Phda.Start_Date_Active, Phda.End_Date_Active, Phda.Last_Update_Login, Phda.Creation_Date, Phda.Supply_Agreement_Flag, Phda.Global_Attribute_Category, Phda.Global_Attribute1, Phda.Global_Attribute2, Phda.Global_Attribute3, Phda.Global_Attribute4, Phda.Global_Attribute5, Phda.Global_Attribute6, Phda.Global_Attribute7, Phda.Global_Attribute8, Phda.Global_Attribute9, Phda.Global_Attribute10, Phda.Global_Attribute11, Phda.Global_Attribute12, Phda.Global_Attribute13, Phda.Global_Attribute14, Phda.Global_Attribute15, Phda.Global_Attribute16, Phda.Global_Attribute17, Phda.Global_Attribute18, Phda.Global_Attribute19, Phda.Global_Attribute20, Phda.Interface_Source_Code, Phda.Reference_Num, Phda.Wf_Item_Type, Phda.Wf_Item_Key, Phda.Pcard_Id, Phda.Price_Update_Tolerance, Phda.Mrc_Rate_Type, Phda.Mrc_Rate_Date, Phda.Mrc_Rate, Phda.Pay_On_Code, Phda.Xml_Flag, Phda.Xml_Send_Date, Phda.Xml_Change_Send_Date, Phda.Global_Agreement_Flag, Phda.Consigned_Consumption_Flag, Phda.Cbc_Accounting_Date, Phda.Consume_Req_Demand_Flag, Phda.Change_Requested_By, Phda.Shipping_Control, Phda.Conterms_Exist_Flag, Phda.Conterms_Articles_Upd_Date, Phda.Conterms_Deliv_Upd_Date, Phda.Encumbrance_Required_Flag, Phda.Pending_Signature_Flag, Phda.Change_Summary, Phda.Document_Creation_Method, Phda.Submit_Date, Phda.Created_Language, Phda.Cpa_Reference, Phda.Style_Id, Phda.Tax_Attribute_Update_Code, Phda.Supplier_Auth_Enabled_Flag, Phda.Cat_Admin_Auth_Enabled_Flag, Phda.Pay_When_Paid, Phda.enable_all_sites, dft.draft_type, dft.mod_effective_date, phda.Ame_Approval_Id, phda.User_Document_Status, phda.Control_Action, phda.Change_Status , phda.uda_template_id, phda.uda_template_date, phda.clm_effective_date, phda.clm_vendor_offer_number, phda.clm_award_administrator, phda.clm_no_signed_copies_to_return, phda.clm_min_guarantee_award_amt, phda.clm_min_guar_award_amt_percent, phda.clm_min_order_amount, phda.clm_max_order_amount, phda.clm_amt_synced_to_agreement, phda.clm_amount_released, phda.clm_external_idv, phda.clm_supplier_name, phda.clm_supplier_site_name, phda.clm_document_number, phda.clm_source_document_id, phda.clm_issuing_office, phda.clm_cotr_office, phda.clm_cotr_contact, phda.clm_priority_code, phda.clm_mod_issuing_office, phda.clm_standard_form, phda.clm_document_format, phda.ame_transaction_type, phda.clm_award_type, phda.clm_contract_officer, null, phda.umbrella_program_id, phda.fon_ref_id, phda.clm_default_dist_flag, phda.clm_contract_finance_code, phda.clm_special_contract_type, phda.clm_payment_instr_code, Dft.draft_sub_type FROM Po_Headers_Draft_All Phda, Po_Drafts Dft WHERE Phda.Draft_Id = Dft.Draft_Id AND NVL(Phda.Delete_Flag,'N') = 'N' UNION ALL SELECT To_Number(NULL), NULL, NULL, To_Number(-1), NULL, NULL, Pha.Email_Address, Pha.Fax, Pha.Supplier_Notif_Method, Pha.Auto_Sourcing_Flag, Pha.Update_Sourcing_Rules_Flag, Pha.Retro_Price_Apply_Updates_Flag, Pha.Retro_Price_Comm_Updates_Flag, Pha.Closed_Code, Pha.Ussgl_Transaction_Code, Pha.Government_Context, Pha.Request_Id, Pha.Program_Application_Id, Pha.Program_Id, Pha.Program_Update_Date, Pha.Org_Id, Pha.Comments, Pha.Reply_Date, Pha.Reply_Method_Lookup_Code, Pha.Rfq_Close_Date, Pha.Quote_Type_Lookup_Code, Pha.Quotation_Class_Code, Pha.Quote_Warning_Delay_Unit, Pha.Quote_Warning_Delay, Pha.Quote_Vendor_Quote_Number, Pha.Acceptance_Required_Flag, Pha.Acceptance_Due_Date, Pha.Closed_Date, Pha.User_Hold_Flag, Pha.Approval_Required_Flag, Pha.Cancel_Flag, Pha.Firm_Status_Lookup_Code, Pha.Firm_Date, Pha.Frozen_Flag, Pha.Edi_Processed_Flag, Pha.Edi_Processed_Status, Pha.Attribute_Category, Pha.Attribute1, Pha.Attribute2, Pha.Attribute3, Pha.Attribute4, Pha.Attribute5, Pha.Attribute6, Pha.Attribute7, Pha.Attribute8, Pha.Attribute9, Pha.Attribute10, Pha.Attribute11, Pha.Attribute12, Pha.Attribute13, Pha.Attribute14, Pha.Attribute15, Pha.Created_By, Pha.Vendor_Id, Pha.Vendor_Site_Id, Pha.Vendor_Contact_Id, Pha.Ship_To_Location_Id, Pha.Bill_To_Location_Id, Pha.Terms_Id, Pha.Ship_Via_Lookup_Code, Pha.Fob_Lookup_Code, Pha.Freight_Terms_Lookup_Code, Pha.Status_Lookup_Code, Pha.Currency_Code, Pha.Rate_Type, Pha.Rate_Date, Pha.Rate, Pha.From_Header_Id, Pha.From_Type_Lookup_Code, Pha.Start_Date, Pha.End_Date, Pha.Blanket_Total_Amount, Pha.Authorization_Status, Pha.Revision_Num, Pha.Revised_Date, Pha.Approved_Flag, Pha.Approved_Date, Pha.Amount_Limit, Pha.Min_Release_Amount, Pha.Note_To_Authorizer, Pha.Note_To_Vendor, Pha.Note_To_Receiver, Pha.Print_Count, Pha.Printed_Date, Pha.Vendor_Order_Num, Pha.Confirming_Order_Flag, Pha.Po_Header_Id, Pha.Agent_Id, Pha.Type_Lookup_Code, Pha.Last_Update_Date, Pha.Last_Updated_By, Pha.Segment1, Pha.Summary_Flag, Pha.Enabled_Flag, Pha.Segment2, Pha.Segment3, Pha.Segment4, Pha.Segment5, Pha.Start_Date_Active, Pha.End_Date_Active, Pha.Last_Update_Login, Pha.Creation_Date, Pha.Supply_Agreement_Flag, Pha.Global_Attribute_Category, Pha.Global_Attribute1, Pha.Global_Attribute2, Pha.Global_Attribute3, Pha.Global_Attribute4, Pha.Global_Attribute5, Pha.Global_Attribute6, Pha.Global_Attribute7, Pha.Global_Attribute8, Pha.Global_Attribute9, Pha.Global_Attribute10, Pha.Global_Attribute11, Pha.Global_Attribute12, Pha.Global_Attribute13, Pha.Global_Attribute14, Pha.Global_Attribute15, Pha.Global_Attribute16, Pha.Global_Attribute17, Pha.Global_Attribute18, Pha.Global_Attribute19, Pha.Global_Attribute20, Pha.Interface_Source_Code, Pha.Reference_Num, Pha.Wf_Item_Type, Pha.Wf_Item_Key, Pha.Pcard_Id, Pha.Price_Update_Tolerance, Pha.Mrc_Rate_Type, Pha.Mrc_Rate_Date, Pha.Mrc_Rate, Pha.Pay_On_Code, Pha.Xml_Flag, Pha.Xml_Send_Date, Pha.Xml_Change_Send_Date, Pha.Global_Agreement_Flag, Pha.Consigned_Consumption_Flag, Pha.Cbc_Accounting_Date, Pha.Consume_Req_Demand_Flag, Pha.Change_Requested_By, Pha.Shipping_Control, Pha.Conterms_Exist_Flag, Pha.Conterms_Articles_Upd_Date, Pha.Conterms_Deliv_Upd_Date, Pha.Encumbrance_Required_Flag, Pha.Pending_Signature_Flag, Pha.Change_Summary, Pha.Document_Creation_Method, Pha.Submit_Date, Pha.Created_Language, Pha.Cpa_Reference, Pha.Style_Id, Pha.Tax_Attribute_Update_Code, Pha.Supplier_Auth_Enabled_Flag, Pha.Cat_Admin_Auth_Enabled_Flag, Pha.Pay_When_Paid, pha.enable_all_sites, NULL, NULL, pha.ame_approval_id, NULL, NULL, NULL, Pha.uda_template_id, Pha.uda_template_date, Pha.clm_effective_date, Pha.clm_vendor_offer_number, Pha.clm_award_administrator, Pha.clm_no_signed_copies_to_return, Pha.clm_min_guarantee_award_amt, Pha.clm_min_guar_award_amt_percent, Pha.clm_min_order_amount, Pha.clm_max_order_amount, Pha.clm_amt_synced_to_agreement, Pha.clm_amount_released, Pha.clm_external_idv, Pha.clm_supplier_name, Pha.clm_supplier_site_name, Pha.clm_document_number, Pha.clm_source_document_id, Pha.clm_issuing_office, Pha.clm_cotr_office, Pha.clm_cotr_contact, Pha.clm_priority_code, Pha.clm_mod_issuing_office, Pha.clm_standard_form, Pha.clm_document_format, Pha.ame_transaction_type, Pha.clm_award_type, Pha.clm_contract_officer, Pha.clm_closeout_status, Pha.umbrella_program_id, Pha.fon_ref_id, Pha.clm_default_dist_flag, Pha.clm_contract_finance_code, Pha.clm_special_contract_type, Pha.clm_payment_instr_code, NUll FROM Po_Headers_All Pha

View Text - HTML Formatted

SELECT DFT.OWNER_USER_ID
, DFT.OWNER_ROLE
, DFT.STATUS
, DFT.DRAFT_ID
, PHDA.CHANGE_ACCEPTED_FLAG
, PHDA.DELETE_FLAG
, PHDA.EMAIL_ADDRESS
, PHDA.FAX
, PHDA.SUPPLIER_NOTIF_METHOD
, PHDA.AUTO_SOURCING_FLAG
, PHDA.UPDATE_SOURCING_RULES_FLAG
, PHDA.RETRO_PRICE_APPLY_UPDATES_FLAG
, PHDA.RETRO_PRICE_COMM_UPDATES_FLAG
, PHDA.CLOSED_CODE
, PHDA.USSGL_TRANSACTION_CODE
, PHDA.GOVERNMENT_CONTEXT
, PHDA.REQUEST_ID
, PHDA.PROGRAM_APPLICATION_ID
, PHDA.PROGRAM_ID
, PHDA.PROGRAM_UPDATE_DATE
, PHDA.ORG_ID
, PHDA.COMMENTS
, PHDA.REPLY_DATE
, PHDA.REPLY_METHOD_LOOKUP_CODE
, PHDA.RFQ_CLOSE_DATE
, PHDA.QUOTE_TYPE_LOOKUP_CODE
, PHDA.QUOTATION_CLASS_CODE
, PHDA.QUOTE_WARNING_DELAY_UNIT
, PHDA.QUOTE_WARNING_DELAY
, PHDA.QUOTE_VENDOR_QUOTE_NUMBER
, PHDA.ACCEPTANCE_REQUIRED_FLAG
, PHDA.ACCEPTANCE_DUE_DATE
, PHDA.CLOSED_DATE
, PHDA.USER_HOLD_FLAG
, PHDA.APPROVAL_REQUIRED_FLAG
, PHDA.CANCEL_FLAG
, PHDA.FIRM_STATUS_LOOKUP_CODE
, PHDA.FIRM_DATE
, PHDA.FROZEN_FLAG
, PHDA.EDI_PROCESSED_FLAG
, PHDA.EDI_PROCESSED_STATUS
, PHDA.ATTRIBUTE_CATEGORY
, PHDA.ATTRIBUTE1
, PHDA.ATTRIBUTE2
, PHDA.ATTRIBUTE3
, PHDA.ATTRIBUTE4
, PHDA.ATTRIBUTE5
, PHDA.ATTRIBUTE6
, PHDA.ATTRIBUTE7
, PHDA.ATTRIBUTE8
, PHDA.ATTRIBUTE9
, PHDA.ATTRIBUTE10
, PHDA.ATTRIBUTE11
, PHDA.ATTRIBUTE12
, PHDA.ATTRIBUTE13
, PHDA.ATTRIBUTE14
, PHDA.ATTRIBUTE15
, PHDA.CREATED_BY
, PHDA.VENDOR_ID
, PHDA.VENDOR_SITE_ID
, PHDA.VENDOR_CONTACT_ID
, PHDA.SHIP_TO_LOCATION_ID
, PHDA.BILL_TO_LOCATION_ID
, PHDA.TERMS_ID
, PHDA.SHIP_VIA_LOOKUP_CODE
, PHDA.FOB_LOOKUP_CODE
, PHDA.FREIGHT_TERMS_LOOKUP_CODE
, PHDA.STATUS_LOOKUP_CODE
, PHDA.CURRENCY_CODE
, PHDA.RATE_TYPE
, PHDA.RATE_DATE
, PHDA.RATE
, PHDA.FROM_HEADER_ID
, PHDA.FROM_TYPE_LOOKUP_CODE
, PHDA.START_DATE
, PHDA.END_DATE
, PHDA.BLANKET_TOTAL_AMOUNT
, PHDA.AUTHORIZATION_STATUS
, PHDA.REVISION_NUM
, PHDA.REVISED_DATE
, PHDA.APPROVED_FLAG
, PHDA.APPROVED_DATE
, PHDA.AMOUNT_LIMIT
, PHDA.MIN_RELEASE_AMOUNT
, PHDA.NOTE_TO_AUTHORIZER
, PHDA.NOTE_TO_VENDOR
, PHDA.NOTE_TO_RECEIVER
, PHDA.PRINT_COUNT
, PHDA.PRINTED_DATE
, PHDA.VENDOR_ORDER_NUM
, PHDA.CONFIRMING_ORDER_FLAG
, PHDA.PO_HEADER_ID
, PHDA.AGENT_ID
, PHDA.TYPE_LOOKUP_CODE
, PHDA.LAST_UPDATE_DATE
, PHDA.LAST_UPDATED_BY
, PHDA.SEGMENT1
, PHDA.SUMMARY_FLAG
, PHDA.ENABLED_FLAG
, PHDA.SEGMENT2
, PHDA.SEGMENT3
, PHDA.SEGMENT4
, PHDA.SEGMENT5
, PHDA.START_DATE_ACTIVE
, PHDA.END_DATE_ACTIVE
, PHDA.LAST_UPDATE_LOGIN
, PHDA.CREATION_DATE
, PHDA.SUPPLY_AGREEMENT_FLAG
, PHDA.GLOBAL_ATTRIBUTE_CATEGORY
, PHDA.GLOBAL_ATTRIBUTE1
, PHDA.GLOBAL_ATTRIBUTE2
, PHDA.GLOBAL_ATTRIBUTE3
, PHDA.GLOBAL_ATTRIBUTE4
, PHDA.GLOBAL_ATTRIBUTE5
, PHDA.GLOBAL_ATTRIBUTE6
, PHDA.GLOBAL_ATTRIBUTE7
, PHDA.GLOBAL_ATTRIBUTE8
, PHDA.GLOBAL_ATTRIBUTE9
, PHDA.GLOBAL_ATTRIBUTE10
, PHDA.GLOBAL_ATTRIBUTE11
, PHDA.GLOBAL_ATTRIBUTE12
, PHDA.GLOBAL_ATTRIBUTE13
, PHDA.GLOBAL_ATTRIBUTE14
, PHDA.GLOBAL_ATTRIBUTE15
, PHDA.GLOBAL_ATTRIBUTE16
, PHDA.GLOBAL_ATTRIBUTE17
, PHDA.GLOBAL_ATTRIBUTE18
, PHDA.GLOBAL_ATTRIBUTE19
, PHDA.GLOBAL_ATTRIBUTE20
, PHDA.INTERFACE_SOURCE_CODE
, PHDA.REFERENCE_NUM
, PHDA.WF_ITEM_TYPE
, PHDA.WF_ITEM_KEY
, PHDA.PCARD_ID
, PHDA.PRICE_UPDATE_TOLERANCE
, PHDA.MRC_RATE_TYPE
, PHDA.MRC_RATE_DATE
, PHDA.MRC_RATE
, PHDA.PAY_ON_CODE
, PHDA.XML_FLAG
, PHDA.XML_SEND_DATE
, PHDA.XML_CHANGE_SEND_DATE
, PHDA.GLOBAL_AGREEMENT_FLAG
, PHDA.CONSIGNED_CONSUMPTION_FLAG
, PHDA.CBC_ACCOUNTING_DATE
, PHDA.CONSUME_REQ_DEMAND_FLAG
, PHDA.CHANGE_REQUESTED_BY
, PHDA.SHIPPING_CONTROL
, PHDA.CONTERMS_EXIST_FLAG
, PHDA.CONTERMS_ARTICLES_UPD_DATE
, PHDA.CONTERMS_DELIV_UPD_DATE
, PHDA.ENCUMBRANCE_REQUIRED_FLAG
, PHDA.PENDING_SIGNATURE_FLAG
, PHDA.CHANGE_SUMMARY
, PHDA.DOCUMENT_CREATION_METHOD
, PHDA.SUBMIT_DATE
, PHDA.CREATED_LANGUAGE
, PHDA.CPA_REFERENCE
, PHDA.STYLE_ID
, PHDA.TAX_ATTRIBUTE_UPDATE_CODE
, PHDA.SUPPLIER_AUTH_ENABLED_FLAG
, PHDA.CAT_ADMIN_AUTH_ENABLED_FLAG
, PHDA.PAY_WHEN_PAID
, PHDA.ENABLE_ALL_SITES
, DFT.DRAFT_TYPE
, DFT.MOD_EFFECTIVE_DATE
, PHDA.AME_APPROVAL_ID
, PHDA.USER_DOCUMENT_STATUS
, PHDA.CONTROL_ACTION
, PHDA.CHANGE_STATUS
, PHDA.UDA_TEMPLATE_ID
, PHDA.UDA_TEMPLATE_DATE
, PHDA.CLM_EFFECTIVE_DATE
, PHDA.CLM_VENDOR_OFFER_NUMBER
, PHDA.CLM_AWARD_ADMINISTRATOR
, PHDA.CLM_NO_SIGNED_COPIES_TO_RETURN
, PHDA.CLM_MIN_GUARANTEE_AWARD_AMT
, PHDA.CLM_MIN_GUAR_AWARD_AMT_PERCENT
, PHDA.CLM_MIN_ORDER_AMOUNT
, PHDA.CLM_MAX_ORDER_AMOUNT
, PHDA.CLM_AMT_SYNCED_TO_AGREEMENT
, PHDA.CLM_AMOUNT_RELEASED
, PHDA.CLM_EXTERNAL_IDV
, PHDA.CLM_SUPPLIER_NAME
, PHDA.CLM_SUPPLIER_SITE_NAME
, PHDA.CLM_DOCUMENT_NUMBER
, PHDA.CLM_SOURCE_DOCUMENT_ID
, PHDA.CLM_ISSUING_OFFICE
, PHDA.CLM_COTR_OFFICE
, PHDA.CLM_COTR_CONTACT
, PHDA.CLM_PRIORITY_CODE
, PHDA.CLM_MOD_ISSUING_OFFICE
, PHDA.CLM_STANDARD_FORM
, PHDA.CLM_DOCUMENT_FORMAT
, PHDA.AME_TRANSACTION_TYPE
, PHDA.CLM_AWARD_TYPE
, PHDA.CLM_CONTRACT_OFFICER
, NULL
, PHDA.UMBRELLA_PROGRAM_ID
, PHDA.FON_REF_ID
, PHDA.CLM_DEFAULT_DIST_FLAG
, PHDA.CLM_CONTRACT_FINANCE_CODE
, PHDA.CLM_SPECIAL_CONTRACT_TYPE
, PHDA.CLM_PAYMENT_INSTR_CODE
, DFT.DRAFT_SUB_TYPE
FROM PO_HEADERS_DRAFT_ALL PHDA
, PO_DRAFTS DFT
WHERE PHDA.DRAFT_ID = DFT.DRAFT_ID
AND NVL(PHDA.DELETE_FLAG
, 'N') = 'N' UNION ALL SELECT TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(-1)
, NULL
, NULL
, PHA.EMAIL_ADDRESS
, PHA.FAX
, PHA.SUPPLIER_NOTIF_METHOD
, PHA.AUTO_SOURCING_FLAG
, PHA.UPDATE_SOURCING_RULES_FLAG
, PHA.RETRO_PRICE_APPLY_UPDATES_FLAG
, PHA.RETRO_PRICE_COMM_UPDATES_FLAG
, PHA.CLOSED_CODE
, PHA.USSGL_TRANSACTION_CODE
, PHA.GOVERNMENT_CONTEXT
, PHA.REQUEST_ID
, PHA.PROGRAM_APPLICATION_ID
, PHA.PROGRAM_ID
, PHA.PROGRAM_UPDATE_DATE
, PHA.ORG_ID
, PHA.COMMENTS
, PHA.REPLY_DATE
, PHA.REPLY_METHOD_LOOKUP_CODE
, PHA.RFQ_CLOSE_DATE
, PHA.QUOTE_TYPE_LOOKUP_CODE
, PHA.QUOTATION_CLASS_CODE
, PHA.QUOTE_WARNING_DELAY_UNIT
, PHA.QUOTE_WARNING_DELAY
, PHA.QUOTE_VENDOR_QUOTE_NUMBER
, PHA.ACCEPTANCE_REQUIRED_FLAG
, PHA.ACCEPTANCE_DUE_DATE
, PHA.CLOSED_DATE
, PHA.USER_HOLD_FLAG
, PHA.APPROVAL_REQUIRED_FLAG
, PHA.CANCEL_FLAG
, PHA.FIRM_STATUS_LOOKUP_CODE
, PHA.FIRM_DATE
, PHA.FROZEN_FLAG
, PHA.EDI_PROCESSED_FLAG
, PHA.EDI_PROCESSED_STATUS
, PHA.ATTRIBUTE_CATEGORY
, PHA.ATTRIBUTE1
, PHA.ATTRIBUTE2
, PHA.ATTRIBUTE3
, PHA.ATTRIBUTE4
, PHA.ATTRIBUTE5
, PHA.ATTRIBUTE6
, PHA.ATTRIBUTE7
, PHA.ATTRIBUTE8
, PHA.ATTRIBUTE9
, PHA.ATTRIBUTE10
, PHA.ATTRIBUTE11
, PHA.ATTRIBUTE12
, PHA.ATTRIBUTE13
, PHA.ATTRIBUTE14
, PHA.ATTRIBUTE15
, PHA.CREATED_BY
, PHA.VENDOR_ID
, PHA.VENDOR_SITE_ID
, PHA.VENDOR_CONTACT_ID
, PHA.SHIP_TO_LOCATION_ID
, PHA.BILL_TO_LOCATION_ID
, PHA.TERMS_ID
, PHA.SHIP_VIA_LOOKUP_CODE
, PHA.FOB_LOOKUP_CODE
, PHA.FREIGHT_TERMS_LOOKUP_CODE
, PHA.STATUS_LOOKUP_CODE
, PHA.CURRENCY_CODE
, PHA.RATE_TYPE
, PHA.RATE_DATE
, PHA.RATE
, PHA.FROM_HEADER_ID
, PHA.FROM_TYPE_LOOKUP_CODE
, PHA.START_DATE
, PHA.END_DATE
, PHA.BLANKET_TOTAL_AMOUNT
, PHA.AUTHORIZATION_STATUS
, PHA.REVISION_NUM
, PHA.REVISED_DATE
, PHA.APPROVED_FLAG
, PHA.APPROVED_DATE
, PHA.AMOUNT_LIMIT
, PHA.MIN_RELEASE_AMOUNT
, PHA.NOTE_TO_AUTHORIZER
, PHA.NOTE_TO_VENDOR
, PHA.NOTE_TO_RECEIVER
, PHA.PRINT_COUNT
, PHA.PRINTED_DATE
, PHA.VENDOR_ORDER_NUM
, PHA.CONFIRMING_ORDER_FLAG
, PHA.PO_HEADER_ID
, PHA.AGENT_ID
, PHA.TYPE_LOOKUP_CODE
, PHA.LAST_UPDATE_DATE
, PHA.LAST_UPDATED_BY
, PHA.SEGMENT1
, PHA.SUMMARY_FLAG
, PHA.ENABLED_FLAG
, PHA.SEGMENT2
, PHA.SEGMENT3
, PHA.SEGMENT4
, PHA.SEGMENT5
, PHA.START_DATE_ACTIVE
, PHA.END_DATE_ACTIVE
, PHA.LAST_UPDATE_LOGIN
, PHA.CREATION_DATE
, PHA.SUPPLY_AGREEMENT_FLAG
, PHA.GLOBAL_ATTRIBUTE_CATEGORY
, PHA.GLOBAL_ATTRIBUTE1
, PHA.GLOBAL_ATTRIBUTE2
, PHA.GLOBAL_ATTRIBUTE3
, PHA.GLOBAL_ATTRIBUTE4
, PHA.GLOBAL_ATTRIBUTE5
, PHA.GLOBAL_ATTRIBUTE6
, PHA.GLOBAL_ATTRIBUTE7
, PHA.GLOBAL_ATTRIBUTE8
, PHA.GLOBAL_ATTRIBUTE9
, PHA.GLOBAL_ATTRIBUTE10
, PHA.GLOBAL_ATTRIBUTE11
, PHA.GLOBAL_ATTRIBUTE12
, PHA.GLOBAL_ATTRIBUTE13
, PHA.GLOBAL_ATTRIBUTE14
, PHA.GLOBAL_ATTRIBUTE15
, PHA.GLOBAL_ATTRIBUTE16
, PHA.GLOBAL_ATTRIBUTE17
, PHA.GLOBAL_ATTRIBUTE18
, PHA.GLOBAL_ATTRIBUTE19
, PHA.GLOBAL_ATTRIBUTE20
, PHA.INTERFACE_SOURCE_CODE
, PHA.REFERENCE_NUM
, PHA.WF_ITEM_TYPE
, PHA.WF_ITEM_KEY
, PHA.PCARD_ID
, PHA.PRICE_UPDATE_TOLERANCE
, PHA.MRC_RATE_TYPE
, PHA.MRC_RATE_DATE
, PHA.MRC_RATE
, PHA.PAY_ON_CODE
, PHA.XML_FLAG
, PHA.XML_SEND_DATE
, PHA.XML_CHANGE_SEND_DATE
, PHA.GLOBAL_AGREEMENT_FLAG
, PHA.CONSIGNED_CONSUMPTION_FLAG
, PHA.CBC_ACCOUNTING_DATE
, PHA.CONSUME_REQ_DEMAND_FLAG
, PHA.CHANGE_REQUESTED_BY
, PHA.SHIPPING_CONTROL
, PHA.CONTERMS_EXIST_FLAG
, PHA.CONTERMS_ARTICLES_UPD_DATE
, PHA.CONTERMS_DELIV_UPD_DATE
, PHA.ENCUMBRANCE_REQUIRED_FLAG
, PHA.PENDING_SIGNATURE_FLAG
, PHA.CHANGE_SUMMARY
, PHA.DOCUMENT_CREATION_METHOD
, PHA.SUBMIT_DATE
, PHA.CREATED_LANGUAGE
, PHA.CPA_REFERENCE
, PHA.STYLE_ID
, PHA.TAX_ATTRIBUTE_UPDATE_CODE
, PHA.SUPPLIER_AUTH_ENABLED_FLAG
, PHA.CAT_ADMIN_AUTH_ENABLED_FLAG
, PHA.PAY_WHEN_PAID
, PHA.ENABLE_ALL_SITES
, NULL
, NULL
, PHA.AME_APPROVAL_ID
, NULL
, NULL
, NULL
, PHA.UDA_TEMPLATE_ID
, PHA.UDA_TEMPLATE_DATE
, PHA.CLM_EFFECTIVE_DATE
, PHA.CLM_VENDOR_OFFER_NUMBER
, PHA.CLM_AWARD_ADMINISTRATOR
, PHA.CLM_NO_SIGNED_COPIES_TO_RETURN
, PHA.CLM_MIN_GUARANTEE_AWARD_AMT
, PHA.CLM_MIN_GUAR_AWARD_AMT_PERCENT
, PHA.CLM_MIN_ORDER_AMOUNT
, PHA.CLM_MAX_ORDER_AMOUNT
, PHA.CLM_AMT_SYNCED_TO_AGREEMENT
, PHA.CLM_AMOUNT_RELEASED
, PHA.CLM_EXTERNAL_IDV
, PHA.CLM_SUPPLIER_NAME
, PHA.CLM_SUPPLIER_SITE_NAME
, PHA.CLM_DOCUMENT_NUMBER
, PHA.CLM_SOURCE_DOCUMENT_ID
, PHA.CLM_ISSUING_OFFICE
, PHA.CLM_COTR_OFFICE
, PHA.CLM_COTR_CONTACT
, PHA.CLM_PRIORITY_CODE
, PHA.CLM_MOD_ISSUING_OFFICE
, PHA.CLM_STANDARD_FORM
, PHA.CLM_DOCUMENT_FORMAT
, PHA.AME_TRANSACTION_TYPE
, PHA.CLM_AWARD_TYPE
, PHA.CLM_CONTRACT_OFFICER
, PHA.CLM_CLOSEOUT_STATUS
, PHA.UMBRELLA_PROGRAM_ID
, PHA.FON_REF_ID
, PHA.CLM_DEFAULT_DIST_FLAG
, PHA.CLM_CONTRACT_FINANCE_CODE
, PHA.CLM_SPECIAL_CONTRACT_TYPE
, PHA.CLM_PAYMENT_INSTR_CODE
, NULL
FROM PO_HEADERS_ALL PHA