IBY_XML_FNDCPT_PAYER_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
PAYER PARTY_ID TRXNMID

Query

SQL_Statement

SELECT XMLConcat( XMLElement("PartyInternalID", ext_fc.party_id), XMLElement("PartyNumber", ext_fc.party_number), XMLElement("Name", ext_fc.party_name), XMLElement("PartyType", XMLElement("Code", ext_fc.party_type), XMLElement("Meaning", party_type_lookup.meaning) ), XMLElement("TaxRegistrationNumber", ext_fc.tax_registration_number), XMLElement("LegalRegistrationNumber", ext_fc.le_registration_number), CASE WHEN ext_fc.party_attr_cat IS NULL THEN NULL ELSE XMLElement("PartyDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'HZ_PARTIES', ext_fc.party_id, NULL)) END, XMLElement("AlternateName",ext_fc.alternate_name), XMLElement("CustomerAccountNumber", ext_fc.account_number), CASE WHEN ext_fc.bill_to_address_id IS NULL THEN NULL ELSE XMLElement("Address", XMLConcat( XMLElement("AddressInternalID", hz_loc.location_id), XMLElement("AddressLine1", hz_loc.address1), XMLElement("AddressLine2", hz_loc.address2), XMLElement("AddressLine3", hz_loc.address3), XMLElement("City", hz_loc.city), XMLElement("County", hz_loc.county), XMLElement("State", hz_loc.state), XMLElement("Country", hz_loc.country), XMLElement("CountryName", terrt.territory_short_name), XMLElement("ISO3DigitCountry", terrb.iso_territory_code), XMLElement("PostalCode", hz_loc.postal_code), XMLElement("AlternateAddressName", null) ) ) END, CASE WHEN ext_fc.party_number IS NULL THEN NULL ELSE XMLElement("FirstPartyReference", ext_fc.party_number) END ) payer, ext_fc.party_id, ext_fc.trxnmid FROM iby_ext_fc_payer_1_0_v ext_fc, fnd_lookup_values party_type_lookup, hz_locations hz_loc, fnd_territories_b terrb, fnd_territories_tl terrt WHERE ext_fc.bill_to_address_id=hz_loc.location_id(+) AND ext_fc.party_type=party_type_lookup.lookup_code(+) AND party_type_lookup.lookup_type(+) = 'PARTY_TYPE' AND party_type_lookup.LANGUAGE(+) = userenv('LANG') AND party_type_lookup.VIEW_APPLICATION_ID(+) = 222 AND (hz_loc.country = terrb.territory_code(+)) AND (terrb.territory_code = terrt.territory_code(+)) AND (terrt.language(+) = USERENV('LANG'))