Query - AP Invoice - PO Information

SELECT distinct
   AIA.INVOICE_NUM Invoice_number,
   -- AIDA.INVOICE_LINE_NUMBER,AIDA.DISTRIBUTION_LINE_NUMBER,
   AIA.INVOICE_DATE, 
   AIA.CREATION_DATE INV_CREATION_DATE,
   AIA.SOURCE,
   AIA.payment_status_flag,
   AIDA.ACCOUNTING_DATE INV_ACCOUNTING_DATE,  
   ATL.NAME INV_PAYMENT_TERM_NAME, 
   ATL1.NAME PO_PAYMENT_TERM_NAME,    
   pha.SEGMENT1 PO_NUMBER, 
   pha.CREATION_DATE PO_CREATION_DATE, 
   pha.APPROVED_DATE PO_APPROVED_DATE,
   AIA.invoice_id
FROM    
   APPS.PO_HEADERS_ALL pha, 
   APPS.PO_LINES_ALL pl, 
   APPS.PO_LINE_LOCATIONS_ALL POL, 
   APPS.PO_DISTRIBUTIONS_ALL PDA, 
   APPS.AP_INVOICE_DISTRIBUTIONS_ALL AIDA, 
   APPS.AP_INVOICES_ALL AIA, 
   APPS.AP_TERMS_TL ATL, 
   APPS.AP_TERMS_TL ATL1 
WHERE 
       PL.PO_LINE_ID = POL.PO_LINE_ID  
  AND  pha.PO_HEADER_ID = PL.PO_HEADER_ID  
  AND  POL.LINE_LOCATION_ID = PDA.LINE_LOCATION_ID 
  AND  AIDA.INVOICE_ID = AIA.INVOICE_ID 
  AND  PDA.PO_DISTRIBUTION_ID = AIDA.PO_DISTRIBUTION_ID  
  AND  AIA.TERMS_ID = ATL.TERM_ID 
  AND  pha.TERMS_ID = ATL1.TERM_ID 
  AND  AIA.invoice_id=12312312;