nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

I need Item_Number with Item_Class and Item_Category in my BIP report

User_IQZBR

I need Item_Number with Item_Class and Item_Category in my BIP report,

How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ?

Find more posts tagged with

BIP

Query

Reporting

SQL

Supply Chain

Accepted answers

Sumanth V -Oracle

@User_IQZBR - Please refer the below documentation for table details and it's primary keys which can be used to join to achieve your requirement.

https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24b/oedsc/egpitemclassesb-28547.html

Please post this question in OTBI community for better responses as the query is related to Fusion application tables.

https://community.oracle.com/products/oracleanalytics/categories/otbi

All comments

Ashish-Oracle

Hello @User_IQZBR,

Is this requirement at the Fusion BIP report end or FDI OAC integrated BIP report end?

Thanks and Regards

Ashish