View: IBY_XML_FNDCPT_PAYER_1_0_V

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

View Text

SELECT XMLCONCAT( XMLELEMENT("PARTYINTERNALID"
, EXT_FC.PARTY_ID)
, XMLELEMENT("PARTYNUMBER"
, EXT_FC.PARTY_NUMBER)
, XMLELEMENT("NAME"
, EXT_FC.PARTY_NAME)
, XMLELEMENT("PARTYTYPE"
, XMLELEMENT("CODE"
, EXT_FC.PARTY_TYPE)
, XMLELEMENT("MEANING"
, PARTY_TYPE_LOOKUP.MEANING) )
, XMLELEMENT("TAXREGISTRATIONNUMBER"
, EXT_FC.TAX_REGISTRATION_NUMBER)
, XMLELEMENT("LEGALREGISTRATIONNUMBER"
, EXT_FC.LE_REGISTRATION_NUMBER)
, CASE WHEN EXT_FC.PARTY_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("PARTYDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'HZ_PARTIES'
, EXT_FC.PARTY_ID
, NULL)) END
, XMLELEMENT("ALTERNATENAME"
, EXT_FC.ALTERNATIVE_NAME)
, XMLELEMENT("CUSTOMERACCOUNTNUMBER"
, EXT_FC.ACCOUNT_NUMBER)
, CASE WHEN EXT_FC.BILL_TO_ADDRESS_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"
, HZ_LOC.COUNTRY)
, XMLELEMENT("POSTALCODE"
, HZ_LOC.POSTAL_CODE)
, XMLELEMENT("LOCATION"
, EXT_FC.LOCATION)
, XMLELEMENT("ALTERNATEADDRESSNAME"
, NULL) ) ) END
, CASE WHEN EXT_FC.PARTY_NUMBER IS NULL THEN NULL ELSE XMLELEMENT("FIRSTPARTYREFERENCE"
, EXT_FC.PARTY_NUMBER) END )
, EXT_FC.PARTY_ID
, EXT_FC.TRXNMID
FROM IBY_EXT_FC_PAYER_1_0_V EXT_FC
, AR_LOOKUPS PARTY_TYPE_LOOKUP
, HZ_LOCATIONS HZ_LOC
WHERE EXT_FC.BILL_TO_ADDRESS_ID=HZ_LOC.LOCATION_ID(+)
AND EXT_FC.PARTY_TYPE=PARTY_TYPE_LOOKUP.LOOKUP_CODE(+)
AND PARTY_TYPE_LOOKUP.LOOKUP_TYPE = 'PARTY_TYPE'

Columns