IBY_XML_FNDCPT_PAYEE_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
XML_PAYEE PARTY_ID LEGAL_ENTITY_ID

Query

SQL_Statement

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) ), 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), XMLElement("TaxRegistrationNumber", payee.tax_registration_number), XMLElement("LegalRegistrationNumber", payee.le_registration_number), XMLElement("LEDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'XLE_FIRSTPARTY_INFORMATION_V', payee.legal_entity_id, NULL)) ), payee.party_id, payee.legal_entity_id FROM iby_ext_fc_payee_1_0_v payee, iby_xml_hr_addr_1_0_v xml_hr_addr WHERE payee.le_location_id = xml_hr_addr.location_id