VIEW: APPS.IBY_XML_FNDCPT_PAYEE_1_0_V

Source

View Text - Preformatted

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), CASE WHEN payee.le_attr_cat IS NULL THEN NULL ELSE XMLElement("LEDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'XLE_FIRSTPARTY_INFORMATION_V', 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

View Text - HTML Formatted

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)
, CASE WHEN PAYEE.LE_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("LEDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'XLE_FIRSTPARTY_INFORMATION_V'
, 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