VIEW: APPS.IBY_XML_FD_INVPAYEE_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("TaxRegistrationNumber", payee.tax_registration_number), xmlelement("LegalEntityRegistrationNumber", payee.le_registration_number), 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("AlternateName", payee.alternate_name), xmlelement("SupplierNumber", payee.supplier_number), CASE WHEN payee.payee_supplier_attr_category IS NULL THEN NULL ELSE xmlelement("SupplierDescriptiveFlexField", iby_extractgen_pvt.get_dffs('PO_VENDORS', payee.vendor_id, NULL)) END, CASE WHEN payee.payee_spplr_site_attr_category IS NULL THEN NULL ELSE xmlelement("SupplierSiteDescriptiveFlexField", iby_extractgen_pvt.get_dffs('PO_VENDOR_SITES_ALL', payee.vendor_site_id, NULL)) END, xmlelement("ContactInfo", iby_fd_extract_gen_pvt.get_payeecontact(payee.payment_id,payee.remit_to_location_id,payee.pmt_party_site_id,payee.pmt_payee_party_id)), CASE WHEN payee.customer_num IS NULL THEN NULL ELSE xmlelement("FirstPartyReference", payee.customer_num) END, CASE WHEN payee.remit_advice_delivery_method IS NULL THEN NULL ELSE xmlelement("RemitAdviceDeliveryMethod", payee.remit_advice_delivery_method) END, CASE WHEN payee.remit_advice_delivery_method = 'EMAIL' THEN xmlelement("RemitAdviceEmail", payee.remit_advice_email) END, CASE WHEN payee.remit_advice_delivery_method = 'FAX' THEN xmlelement("RemitAdviceFax", payee.remit_advice_fax) END, xmlelement("AdditionalInformation", payee.additional_information) ) PAYEE, payee.party_id PARTY_ID, payee.payment_id PAYMENT_ID FROM iby_ext_fd_invpayee_1_0_vd payee, fnd_territories_vl te WHERE payee.payment_id = payee.payment_id AND payee.payee_country = te.territory_code(+)

View Text - HTML Formatted

SELECT XMLCONCAT(XMLELEMENT("PARTYINTERNALID"
, PAYEE.PARTY_ID)
, XMLELEMENT("PARTYNUMBER"
, PAYEE.PARTY_NUMBER)
, XMLELEMENT("NAME"
, PAYEE.PARTY_NAME)
, XMLELEMENT("TAXREGISTRATIONNUMBER"
, PAYEE.TAX_REGISTRATION_NUMBER)
, XMLELEMENT("LEGALENTITYREGISTRATIONNUMBER"
, PAYEE.LE_REGISTRATION_NUMBER)
, 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("ALTERNATENAME"
, PAYEE.ALTERNATE_NAME)
, XMLELEMENT("SUPPLIERNUMBER"
, PAYEE.SUPPLIER_NUMBER)
, CASE WHEN PAYEE.PAYEE_SUPPLIER_ATTR_CATEGORY IS NULL THEN NULL ELSE XMLELEMENT("SUPPLIERDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS('PO_VENDORS'
, PAYEE.VENDOR_ID
, NULL)) END
, CASE WHEN PAYEE.PAYEE_SPPLR_SITE_ATTR_CATEGORY IS NULL THEN NULL ELSE XMLELEMENT("SUPPLIERSITEDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS('PO_VENDOR_SITES_ALL'
, PAYEE.VENDOR_SITE_ID
, NULL)) END
, XMLELEMENT("CONTACTINFO"
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYEECONTACT(PAYEE.PAYMENT_ID
, PAYEE.REMIT_TO_LOCATION_ID
, PAYEE.PMT_PARTY_SITE_ID
, PAYEE.PMT_PAYEE_PARTY_ID))
, CASE WHEN PAYEE.CUSTOMER_NUM IS NULL THEN NULL ELSE XMLELEMENT("FIRSTPARTYREFERENCE"
, PAYEE.CUSTOMER_NUM) END
, CASE WHEN PAYEE.REMIT_ADVICE_DELIVERY_METHOD IS NULL THEN NULL ELSE XMLELEMENT("REMITADVICEDELIVERYMETHOD"
, PAYEE.REMIT_ADVICE_DELIVERY_METHOD) END
, CASE WHEN PAYEE.REMIT_ADVICE_DELIVERY_METHOD = 'EMAIL' THEN XMLELEMENT("REMITADVICEEMAIL"
, PAYEE.REMIT_ADVICE_EMAIL) END
, CASE WHEN PAYEE.REMIT_ADVICE_DELIVERY_METHOD = 'FAX' THEN XMLELEMENT("REMITADVICEFAX"
, PAYEE.REMIT_ADVICE_FAX) END
, XMLELEMENT("ADDITIONALINFORMATION"
, PAYEE.ADDITIONAL_INFORMATION) ) PAYEE
, PAYEE.PARTY_ID PARTY_ID
, PAYEE.PAYMENT_ID PAYMENT_ID
FROM IBY_EXT_FD_INVPAYEE_1_0_VD PAYEE
, FND_TERRITORIES_VL TE
WHERE PAYEE.PAYMENT_ID = PAYEE.PAYMENT_ID
AND PAYEE.PAYEE_COUNTRY = TE.TERRITORY_CODE(+)