View: IBY_EXT_FD_PAYEE_1_0_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_EXT_FD_PAYEE_1_0_V

View Text

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(SITE.PARTY_SITE_NAME
, VENDOR_SITE.VENDOR_SITE_CODE) 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(NVL(PMT.SUPPLIER_SITE_ID
, VENDOR.VENDOR_ID)
, DECODE(NVL(PMT.SUPPLIER_SITE_ID
, -1)
, -1
, 'SUPPLIER'
, 'SUPPLIER_SITE')) 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
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'

Columns