SELECT approved_date aa, CLOSED_CODE , USSGL_TRANSACTION_CODE , GOVERNMENT_CONTEXT , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , ORG_ID , 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 , APPROVAL_REQUIRED_FLAG , CANCEL_FLAG , FIRM_STATUS_LOOKUP_CODE , FIRM_DATE , FROZEN_FLAG , EDI_PROCESSED_FLAG , EDI_PROCESSED_STATUS , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , CREATED_BY , 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 , PO_HEADER_ID , AGENT_ID , TYPE_LOOKUP_CODE , LAST_UPDATE_DATE , LAST_UPDATED_BY , SEGMENT1 , SUMMARY_FLAG , ENABLED_FLAG , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , START_DATE_ACTIVE , END_DATE_ACTIVE , LAST_UPDATE_LOGIN , CREATION_DATE , SUPPLY_AGREEMENT_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 ,INTERFACE_SOURCE_CODE ,REFERENCE_NUM ,WF_ITEM_TYPE ,WF_ITEM_KEY ,PCARD_ID ,PRICE_UPDATE_TOLERANCE , 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
FROM PO_HEADERS_ALL where approved_date is not null and segment1 in ('3063','3061' ) --po_number
order by approved_date desc
select * from PO_LINES_ALL pl where pl.po_header_id in (101925,6777)
历史记录
po_headers_archive_all
po_lines_archive_all
po_line_locations_archive_all
