Tax Registration from Supplier Address out of Supplier Real Time OTBI

Summary

Looking for Supplier's Tax Registration Linked to Address

Content

I'm building a supplier report inside the Supplier - Supplier Real Time subject area and attempting to pull the Tax Registration Number from the supplier's address. However the only Tax Registration field available is pulling the value from the profile's tax registration, *not* the address, which is more specific and could vary depending on which office the supplier is using. Is this field accessible from OTBI? 

 

 

Code Snippet

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Supplier - Supplier Real Time"."- Income Tax"."Tax Payer ID" s_1,
   "Supplier - Supplier Real Time"."- Income Tax"."Tax Registration Number" s_2,
   "Supplier - Supplier Real Time"."- Income Tax"."Withholding Tax Group" s_3,
   "Supplier - Supplier Real Time"."- Procurement BU"."Default Legal Entity Name" s_4,
   "Supplier - Supplier Real Time"."- Supplier Profile"."Supplier Name" s_5,
   "Supplier - Supplier Real Time"."- Supplier Profile"."Supplier Number" s_6,
   "Supplier - Supplier Real Time"."- Supplier Profile"."Supplier Type" s_7,
   "Supplier - Supplier Real Time"."- Supplier