Developed the Competitive Product detail page to display full information about competitor products.

Implemented joins with related tables (e.g., Brand, Category, Price List, Currency, Tax Type, Tax Region, Outlet, Warehouse, etc.) to fetch and present relational data in one consolidated view.

Displayed both competitive product–specific details (code, name, description, competitor brand, pricing, market position) and linked information (category, tax details, price list references, outlet/warehouse availability).

Used Prisma ORM relational queries (include, nested selects) to efficiently load associated records.

Designed a user-friendly and well-structured UI layout, making it easy to compare competitive product data against internal product details.

Followed a modular and extensible coding approach, enabling future enhancements such as linking suppliers, customer feedback, or competitor analysis reports.