select
s.segment1 "Supplier Number",
hps.party_site_name "Address Name",
haou.name "Operating Unit",
ass.vendor_site_code "Supplier Site",
ass.invoice_amount_limit "Invoicing: Amount Limit",
null "Invoicing: Tolerance",
decode(ass.match_option,
'R','Receipt',
'P','Purchase Order',
null) "Inv: Match Option",
ass.invoice_currency_code "Inv: Currency",
ass.hold_all_payments_flag "Inv: Hold - All Invoices",
ass.hold_unmatched_invoices_flag "Inv: Hold - Unmatched Inv",
ass.hold_future_payments_flag "Inv: Hold - Unvalidated Inv",
ass.hold_reason "Inv: Payment Hold Reason",
ato.tolerance_name "Inv: Service Tolerance",
ass.payment_currency_code "Payment: Currency",
ass.payment_priority "Payment: Priority",
ass.pay_group_lookup_code "Payment: Pay Group",
flv.meaning "Payment: Deduct Bank Charge",
at.name "Terms: Terms",
ass.terms_date_basis "Terms: Terms Date Basis",
ass.pay_date_basis_lookup_code "Terms: Pay Date Basis",
ass.retainage_rate "Terms: Retainage Rate",
ass.always_take_disc_flag "Terms: Take Discount",
ass.exclude_freight_from_discount "Terms: Ex Freight Discount",
s.vendor_id,
ass.vendor_site_id
from
ap_suppliers s,
ap_supplier_sites ass,
hz_party_sites hps,
hr_all_organization_units haou,
ap_tolerances ato,
ap_terms at,
fnd_lookup_values_vl flv
where
1=1
and ass.vendor_id = s.vendor_id
and hps.party_id = s.party_id
and hps.party_site_id = ass.party_site_id
and haou.organization_id = ass.org_id
and ato.tolerance_id (+) = ass.services_tolerance_id
and at.term_id (+) = ass.terms_id
and flv.lookup_type (+) = 'BANK CHARGE BEARER'
and flv.lookup_code (+) = ass.bank_charge_bearer
and s.segment1 = '112345'
order by 1,2,3,4