View: IBY_XML_FNDCPT_PAYEE_1_0_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_XML_FNDCPT_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("LEGALENTITYINTERNALID"
, PAYEE.LEGAL_ENTITY_ID)
, XMLELEMENT("LEGALENTITYNAME"
, PAYEE.LEGAL_ENTITY_NAME)
, XMLELEMENT("ADDRESS"
, XML_HR_ADDR.ADDRESS)
, CASE WHEN PAYEE.LE_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("LEDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'XLE_ENTITY_PROFILES_B'
, PAYEE.LEGAL_ENTITY_ID
, NULL)) END )
, PAYEE.PARTY_ID
, PAYEE.LEGAL_ENTITY_ID
FROM IBY_EXT_FD_PAYER_1_0_V PAYEE
, IBY_XML_HR_ADDR_1_0_V XML_HR_ADDR
WHERE PAYEE.LE_LOCATION_ID = XML_HR_ADDR.LOCATION_ID

Columns