IBY_XML_FD_PAYER_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
PAYER PARTY_ID LEGAL_ENTITY_ID PAYMENT_ID

Query

SQL_Statement

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)), XMLElement("LEDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'XLE_FIRSTPARTY_INFORMATION_V', payer.legal_entity_id, NULL)) ), payer.party_id, payer.legal_entity_id, payer.payment_id FROM iby_ext_fd_payer_1_0_vd payer