VIEW: APPS.IBY_XML_FD_PAYER_1_0_V

Source

View Text - Preformatted

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("LegalEntityRegistrationNumber", 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", IBY_FD_EXTRACT_GEN_PVT.Get_Hr_Address(payer.le_location_id)), 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_FIRSTPARTY_INFORMATION_V', payer.legal_entity_id, NULL)) END ), payer.party_id, payer.legal_entity_id, payer.payment_id FROM iby_ext_fd_payer_1_0_vd payer

View Text - HTML Formatted

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("LEGALENTITYREGISTRATIONNUMBER"
, 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"
, IBY_FD_EXTRACT_GEN_PVT.GET_HR_ADDRESS(PAYER.LE_LOCATION_ID))
, 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_FIRSTPARTY_INFORMATION_V'
, PAYER.LEGAL_ENTITY_ID
, NULL)) END )
, PAYER.PARTY_ID
, PAYER.LEGAL_ENTITY_ID
, PAYER.PAYMENT_ID
FROM IBY_EXT_FD_PAYER_1_0_VD PAYER