View: IBY_XML_FD_PAYER_1_0_V

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

View Text

SELECT XMLCONCAT( XMLELEMENT("PARTYINTERNALID"
, PAYER.PARTY_ID)
, XMLELEMENT("PARTYNUMBER"
, PAYER.PARTY_NUMBER)
, XMLELEMENT("NAME"
, PAYER.PARTY_NAME)
, XMLELEMENT("PARTYTYPE"
, XMLELEMENT("CODE"
, PAYER.PARTY_TYPE)
, XMLELEMENT("MEANING"
, PAYER.PARTY_TYPE_MEANING) )
, XMLELEMENT("TAXREGISTRATIONNUMBER"
, PAYER.TAX_REGISTRATION_NUMBER)
, XMLELEMENT("LEGALREGISTRATIONNUMBER"
, PAYER.LE_REGISTRATION_NUMBER)
, CASE WHEN PAYER.PARTY_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("PARTYDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'HZ_PARTIES'
, PAYER.PARTY_ID
, NULL)) END
, XMLELEMENT("LEGALENTITYINTERNALID"
, PAYER.LEGAL_ENTITY_ID)
, XMLELEMENT("LEGALENTITYNAME"
, PAYER.LEGAL_ENTITY_NAME)
, XMLELEMENT("ADDRESS"
, XML_HR_ADDR.ADDRESS)
, XMLELEMENT("CONTACTINFO"
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYERCONTACT(PARTY_ID))
, CASE WHEN PAYER.LE_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("LEDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'XLE_ENTITY_PROFILES_B'
, PAYER.LEGAL_ENTITY_ID
, NULL)) END )
, PAYER.PARTY_ID
, PAYER.LEGAL_ENTITY_ID
FROM IBY_EXT_FD_PAYER_1_0_V PAYER
, IBY_XML_HR_ADDR_1_0_V XML_HR_ADDR
WHERE PAYER.LE_LOCATION_ID = XML_HR_ADDR.LOCATION_ID

Columns