Unable to find Purchase Order in iProcurement (11.5.7) - Urgent Producntion Issue

 Hi All,

   I am unable to find the Purchase Order with Open/Closed status when i search in iProcurement home page (search). Few Orders are visible and few not. I am using 11.5.7.

Below is the data for your analysis, in which the first PO 1010785 is visible when I search, but the other two (in Red )are not visible . I know its trouble to read the data in this window. Apologies to ask take the risk to copy paste the text in Wordpad and analyze

select * from apps.po_headers_all where segment1 in (1010785, 1060108, 1058788) 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 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 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 SUPPLY_AGREEMENT_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