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
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
Comments
Post a Comment