po_query2

SELECT
          PV.SEGMENT1
,        PV.VENDOR_NAME
,        PVSA.VENDOR_SITE_CODE
,        PVSA.ADDRESS_LINE1
,        PVSA.ADDRESS_LINE2
,        PVSA.CITY
,        PVSA.STATE
,        PVSA.ZIP
,        PVSA.COUNTRY
,        PVSA.AREA_CODE
,        PVSA.PHONE
,        AIA.INVOICE_NUM
,        AIA.INVOICE_DATE
,        AIA.DESCRIPTION
,        AIA.CREATION_DATE
,        PAPF.FULL_NAME
,        AIA.INVOICE_CURRENCY_CODE
,        AIA.INVOICE_AMOUNT
,        GSOB.CURRENCY_CODE
,        AIA.BASE_AMOUNT
,        AIDA.DISTRIBUTION_LINE_NUMBER
,        AIDA.ACCOUNTING_DATE
,        AIDA.DESCRIPTION
,        AIDA.AMOUNT
,        AIDA.BASE_AMOUNT
,        GCC.SEGMENT1
,        GCC.SEGMENT2
,        GCC.SEGMENT3
,        GCC.SEGMENT4
,        PHA.SEGMENT1
,        PLA.LINE_NUM
,        PPF.FULL_NAME
,        ACA.CURRENCY_CODE
,        ACA.CHECK_NUMBER
,        ACA.CHECK_DATE
,        ACA.AMOUNT
,        ACA.BASE_AMOUNT
FROM
PO_VENDORS PV,
PO_VENDOR_SITES_ALL PVSA,
AP_INVOICES_ALL AIA,
GL_SETS_OF_BOOKS GSOB,
AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
GL_CODE_COMBINATIONS GCC,
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_DISTRIBUTIONS_ALL PDA,
PER_PEOPLE_F PPF,
PER_ALL_PEOPLE_F PAPF,
AP_INVOICE_PAYMENTS_ALL AIPA,
AP_CHECKS_ALL ACA
WHERE
     PV.VENDOR_ID=PVSA.VENDOR_ID
AND     PVSA.VENDOR_SITE_ID=AIA.VENDOR_SITE_ID
AND     AIA.INVOICE_ID=AIDA.INVOICE_ID
AND     AIA.CREATED_BY=PPF.CREATED_BY
AND     AIA.INVOICE_ID=AIPA.INVOICE_ID
AND      AIPA.CHECK_ID=ACA.CHECK_ID
AND     AIA.SET_OF_BOOKS_ID=GSOB.SET_OF_BOOKS_ID
AND     AIDA.DIST_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID
AND     AIDA.PO_DISTRIBUTION_ID=PDA.PO_DISTRIBUTION_ID
AND     PHA.AGENT_ID=PPF.PERSON_ID
AND     PPF.PERSON_ID=PAPF.PERSON_ID
AND     PDA.PO_LINE_ID(+)=PLA.PO_LINE_ID
AND     PLA.PO_HEADER_ID(+)=PHA.PO_HEADER_ID


AND  AIDA.ACCOUNTING_DATE BETWEEN TO_CHAR(:START_ACC_DATE ,'DD-MON-YYYY') AND TO_CHAR(:END_ACC_DATE,'DD-MON-YYYY')
   
AND     PV.VENDOR_NAME = NVL(:P_VENDOR_NAME,PV.VENDOR_NAME)