That's interesting. This worked for me. Not sure why would it not work for you. Here is the code snippet that you can try running for the above mentioned logic. This gives me supplier phone no per supplier: select DISTINCT B.PARTY_NAME, D.RAW_PHONE_NUMBER, B.PARTY_TYPE,A.VENDOR_TYPE_LOOKUP_CODE AS Supplier_Vendor_Type FROM…

Hi, You need to use HZ_CONTACT_POINTS to get primary phone numbers for suppliers 1. Find Party_id from HZ_PARTIES for each supplier from POZ_SUPPLIERS 2. Find corresponding PARTY_SITE_ID FROM HZ_PARTY_SITES 3. Join PARTY_SIDE_ID with OWNER_TABLE_ID from HZ_CONTACT_POINTS 4.Filter on the below 4 columns within…

HI, I did post it in EBS group and Oracle Fusion Financials. Not sure if there are other groups that are more relevant. I have not yet received any hits on the question. Seems like there is no FA apps table that lists Book Value of an asset by year. Thanks, Anand

I had already come across this in my research and it does not look at NBV. But I think its a on-the fly calc too. Thanks anyways. Thread is closed. Regards, Anand

HI , Yes. I am trying to seek which would the relevant fixed asset tables that will contain these values ( Depreciated Book Value, Remaining life) so that I can complete my BI Publisher query. Would you be able to guide me on which would be the correct group to query this question? Thanks, Anand