Tech Trainings

July 11, 2024 by admin

-------AP Invoice
----List of Value for the parameter 

select distinct INVOICE_TYPE_LOOKUP_CODE  from AP_INVOICES_ALL  
 

select supplier_num , vendor_id from poz_suppliers   

---------------------------------------------------------------------------------------
SELECT 
psup.segment1 supplier_num,
hp.party_name supplier_name,
aia.invoice_id,
aia.invoice_num,
aia.vendor_id,
aia.invoice_amount,
aia.INVOICE_TYPE_LOOKUP_CODE,
aia.description ,
aia.creation_date
 FROM AP_INVOICES_ALL aia
  , poz_suppliers psup
  , hz_parties hp 
 WHERE 1=1 
---  AND aia.INVOICE_TYPE_LOOKUP_CODE = :P_INVOICE_TYPE
  AND   (aia.INVOICE_TYPE_LOOKUP_CODE IN (:P_INVOICE_TYPE) OR least(:P_INVOICE_TYPE) IS NULL)
 AND psup.vendor_id = aia.vendor_id 
 and psup.party_id = hp.party_id 
  AND  (psup.vendor_id  IN (:P_SUPPLIER_ID) OR least(:P_SUPPLIER_ID) IS NULL)

——-PO Report ——-LOV Value ———-

SELECT segment1 FROM PO_HEADERS_ALL

—Query

SELECT
pha.po_header_id, pha.segment1 po_number, pha.DOCUMENT_STATUS, pha.TYPE_LOOKUP_CODE,
pla.list_price, pla.LINE_TYPE_ID, pla.LINE_NUM, pla.ITEM_DESCRIPTION, pla.UOM_CODE,
pla.UNIT_PRICE, pla.QUANTITY
FROM PO_HEADERS_ALL pha , PO_LINES_ALL pla
where 1=1
and pha.po_header_id = pla.po_header_id
AND (pha.segment1 IN (:P_PO_NUMBER) OR least(:P_PO_NUMBER) IS NULL)

Comments |1|