Query for supplier list in Oracle ebs R12

 select
AP.VENDOR_NAME VENDOR_NAME,
         AP.SEGMENT1 VENDOR_NUM,
         AP.VENDOR_ID ,
         APS.VENDOR_SITE_ID SITE_ID,
         APS.VENDOR_SITE_CODE VENDOR_SITE_CODE
FROM     AP_SUPPLIERS AP,
         AP_SUPPLIER_SITES_ALL APS
WHERE    1 = 1
AND      AP.VENDOR_ID = APS.VENDOR_ID
and aps.org_id = 1285
order by 1

Property Manager Cashflow report query

 

        SELECT
            pla.lease_num        lease_num,
            pla.name             lease_name,
            LOOK.MEANING LEASE_TYPE,
            trunc(ppsa.schedule_date)   schedule_date,
            SUM(ppia.actual_amount) cash
        FROM            
            pn_leases_all              pla,
            pn_payment_terms_all       pt,
            pn_payment_items_all       ppia,
            pn_payment_schedules_all   ppsa,
             FND_LOOKUPS LOOK
        WHERE
            pla.lease_id = pt.lease_id
            AND pt.payment_term_id = ppia.payment_term_id
            AND ppia.payment_schedule_id = ppsa.payment_schedule_id
            and  LOOK.LOOKUP_TYPE = 'PN_LEASE_TYPE'
            AND LOOK.LOOKUP_CODE = pla.LEASE_TYPE_CODE
            --and pla.org_id=123
            and pla.lease_num= 'ABC_123'
            --pla.lease_num BETWEEN :p_low_lease_num AND :p_high_lease_num--
        GROUP BY
            pla.lease_num,
            pla.name,
            ppsa.schedule_date,
            LOOK.MEANING
            order by ppsa.schedule_date, pla.lease_num;