View: IBY_XML_FD_PAYEE_1_0_V

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

View Text

SELECT XMLCONCAT( XMLELEMENT("PARTYINTERNALID"
, PAYEE.PARTY_ID)
, XMLELEMENT("PARTYNUMBER"
, PAYEE.PARTY_NUMBER)
, XMLELEMENT("NAME"
, PAYEE.PARTY_NAME)
, XMLELEMENT("PARTYTYPE"
, XMLELEMENT("CODE"
, PAYEE.PARTY_TYPE)
, XMLELEMENT("MEANING"
, PAYEE.PARTY_TYPE_MEANING) )
, XMLELEMENT("TAXREGISTRATIONNUMBER"
, PAYEE.TAX_REGISTRATION_NUMBER)
, XMLELEMENT("LEGALREGISTRATIONNUMBER"
, PAYEE.LE_REGISTRATION_NUMBER)
, CASE WHEN PAYEE.PARTY_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("PARTYDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'HZ_PARTIES'
, PAYEE.PARTY_ID
, NULL)) END
, XMLELEMENT("ALTERNATENAME"
, PAYEE.ALTERNATE_NAME)
, XMLELEMENT("SUPPLIERNUMBER"
, PAYEE.SUPPLIER_NUMBER)
, CASE WHEN PAYEE.PAYMENT_LOCATION_ID IS NULL THEN NULL ELSE XMLELEMENT("ADDRESS"
, XMLCONCAT( XMLELEMENT("ADDRESSINTERNALID"
, HZ_LOC.LOCATION_ID)
, XMLELEMENT("ADDRESSLINE1"
, HZ_LOC.ADDRESS1)
, XMLELEMENT("ADDRESSLINE2"
, HZ_LOC.ADDRESS2)
, XMLELEMENT("ADDRESSLINE3"
, HZ_LOC.ADDRESS3)
, XMLELEMENT("CITY"
, HZ_LOC.CITY)
, XMLELEMENT("COUNTY"
, HZ_LOC.COUNTY)
, XMLELEMENT("STATE"
, HZ_LOC.STATE)
, XMLELEMENT("COUNTRY"
, HZ_LOC.COUNTRY)
, XMLELEMENT("COUNTRYNAME"
, TE.TERRITORY_SHORT_NAME)
, XMLELEMENT("POSTALCODE"
, HZ_LOC.POSTAL_CODE)
, XMLELEMENT("ADDRESSNAME"
, PAYEE.SITE_NAME)
, XMLELEMENT("ALTERNATEADDRESSNAME"
, PAYEE.ALTERNATE_SITE_NAME)
, XMLELEMENT("PREFORMATTEDCONCATENATEDADDRESS"
, HZ_FORMAT_PUB.FORMAT_ADDRESS(HZ_LOC.LOCATION_ID))
, XMLELEMENT("PREFORMATTEDMAILINGADDRESS"
, HZ_FORMAT_PUB.FORMAT_ADDRESS(HZ_LOC.LOCATION_ID
, 'POSTAL_ADDR')) ) ) END
, XMLELEMENT("CONTACTINFO"
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYEECONTACT(PAYMENT_ID))
, CASE WHEN PAYEE.CUSTOMER_NUM IS NULL THEN NULL ELSE XMLELEMENT("FIRSTPARTYREFERENCE"
, PAYEE.CUSTOMER_NUM) END )
, PAYEE.PARTY_ID
, PAYEE.PAYMENT_ID
FROM IBY_EXT_FD_PAYEE_1_0_V PAYEE
, HZ_LOCATIONS HZ_LOC
, FND_TERRITORIES_VL TE
WHERE PAYEE.PAYMENT_LOCATION_ID = HZ_LOC.LOCATION_ID(+)
AND HZ_LOC.COUNTRY = TE.TERRITORY_CODE(+)

Columns