How to find out Standard Purchase order EDI Flag generated or not
select a.SEGMENT1 PO_NUMBER, A.APPROVED_DATE,A.AUTHORIZATION_STATUS, B.VENDOR_NAME,C.VENDOR_SITE_CODE, a.edi_processed_flag, a.print_count, A.START_DATE,A.END_DATE, c.PURCHASING_SITE_FLAG Pur_Flag,c.PAY_SITE_FLAG,c.inactive_date, C.ECE_TP_LOCATION_CODE, A.CLOSED_DATE,A.TYPE_LOOKUP_CODE,A.CANCEL_DATE, A.CLOSED_FLAG,A.CANCEL_FLAG,A.FROZEN_FLAG,A.APPROVED_DATE,A.CREATION_DATE, B.VENDOR_ID,C.VENDOR_SITE_ID from APPS.PO_HEADERS_ALL A, APPS.AP_VENDORS_v b, APPS.PO_VENDOR_SITES_ALL c where A.vendor_id=b.vendor_id AND A.VENDOR_SITE_ID=C.VENDOR_SITE_ID AND A.org_id=123 --AND A.TYPE_LOOKUP_CODE='BLANKET' --AND C.ECE_TP_LOCATION_CODE IS NOT NULL --AND a.vendor_id=123 --AND A.CLOSED_DATE is null --AND A.SEGMENT1='123' AND B.VENDOR_NAME='SUPPLIER NAME' And Trunc(A.Creation_Date) > '01-Oct-2017' order by A.APPROVED_DATE desc