VIEW: APPS.IBY_EXT_FD_PAYEE_1_0_V

Source

View Text - Preformatted

SELECT pmt.payment_id payment_id, party.party_id party_id, vendor.vendor_id vendor_id, pmt.supplier_site_id vendor_site_id, vendor.segment1 supplier_number, party.party_number party_number, party.party_name party_name, decode(party.party_type, 'ORGANIZATION', party.organization_name_phonetic, 'PERSON', party.person_first_name_phonetic || ' ' || party.person_last_name_phonetic) alternate_name, nvl(vendor_site.vendor_site_code, site.party_site_name) site_name, vendor_site.vendor_site_code_alt alternate_site_name, party.party_type party_type, party_type_lookup.meaning party_type_meaning, IBY_FD_EXTRACT_GEN_PVT.Get_Payee_TaxRegistration(vendor.vendor_id, pmt.supplier_site_id) tax_registration_number, IBY_FD_EXTRACT_GEN_PVT.Get_Payee_LegalRegistration(vendor.vendor_id, pmt.supplier_site_id, vendor_site.country) le_registration_number, party.attribute_category party_attr_cat, pmt.remit_to_location_id payment_location_id, vendor.customer_num customer_num, site.party_site_id FROM iby_payments_all pmt, po_vendors vendor, po_vendor_sites_all vendor_site, hz_parties party, hz_party_sites site, ar_lookups party_type_lookup WHERE pmt.payee_party_id = party.party_id /*-- Omar suspect AP may support one party multiple vendors -- so get the vendor via vendor_site -- AND pmt.payee_party_id = vendor.party_id */ AND pmt.supplier_site_id = vendor_site.vendor_site_id(+) AND vendor_site.vendor_id = vendor.vendor_id(+) AND pmt.party_site_id = site.party_site_id(+) AND party.party_type = party_type_lookup.lookup_code AND party_type_lookup.lookup_type = 'PARTY_TYPE'

View Text - HTML Formatted

SELECT PMT.PAYMENT_ID PAYMENT_ID
, PARTY.PARTY_ID PARTY_ID
, VENDOR.VENDOR_ID VENDOR_ID
, PMT.SUPPLIER_SITE_ID VENDOR_SITE_ID
, VENDOR.SEGMENT1 SUPPLIER_NUMBER
, PARTY.PARTY_NUMBER PARTY_NUMBER
, PARTY.PARTY_NAME PARTY_NAME
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ORGANIZATION_NAME_PHONETIC
, 'PERSON'
, PARTY.PERSON_FIRST_NAME_PHONETIC || ' ' || PARTY.PERSON_LAST_NAME_PHONETIC) ALTERNATE_NAME
, NVL(VENDOR_SITE.VENDOR_SITE_CODE
, SITE.PARTY_SITE_NAME) SITE_NAME
, VENDOR_SITE.VENDOR_SITE_CODE_ALT ALTERNATE_SITE_NAME
, PARTY.PARTY_TYPE PARTY_TYPE
, PARTY_TYPE_LOOKUP.MEANING PARTY_TYPE_MEANING
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYEE_TAXREGISTRATION(VENDOR.VENDOR_ID
, PMT.SUPPLIER_SITE_ID) TAX_REGISTRATION_NUMBER
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYEE_LEGALREGISTRATION(VENDOR.VENDOR_ID
, PMT.SUPPLIER_SITE_ID
, VENDOR_SITE.COUNTRY) LE_REGISTRATION_NUMBER
, PARTY.ATTRIBUTE_CATEGORY PARTY_ATTR_CAT
, PMT.REMIT_TO_LOCATION_ID PAYMENT_LOCATION_ID
, VENDOR.CUSTOMER_NUM CUSTOMER_NUM
, SITE.PARTY_SITE_ID
FROM IBY_PAYMENTS_ALL PMT
, PO_VENDORS VENDOR
, PO_VENDOR_SITES_ALL VENDOR_SITE
, HZ_PARTIES PARTY
, HZ_PARTY_SITES SITE
, AR_LOOKUPS PARTY_TYPE_LOOKUP
WHERE PMT.PAYEE_PARTY_ID = PARTY.PARTY_ID /*-- OMAR SUSPECT AP MAY SUPPORT ONE PARTY MULTIPLE VENDORS -- SO GET THE VENDOR VIA VENDOR_SITE --
AND PMT.PAYEE_PARTY_ID = VENDOR.PARTY_ID */
AND PMT.SUPPLIER_SITE_ID = VENDOR_SITE.VENDOR_SITE_ID(+)
AND VENDOR_SITE.VENDOR_ID = VENDOR.VENDOR_ID(+)
AND PMT.PARTY_SITE_ID = SITE.PARTY_SITE_ID(+)
AND PARTY.PARTY_TYPE = PARTY_TYPE_LOOKUP.LOOKUP_CODE
AND PARTY_TYPE_LOOKUP.LOOKUP_TYPE = 'PARTY_TYPE'