Need to get a report for PO's where we can filter by BU's
Summary
Need to get a report for PO's where we can filter by BU'sContent
Hello,
Grateful if you can help on how to get a list of all GRN's for Received Shipments for a Specific BU please?
Below are the previous SR's raised and now that we got the knowledge on how to build the report, can you help us with the exact query to join the 4 table names provided to build the report please.
Table names
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL
Thank you
Yogesh
Version
20A
Tagged:
- Category 52
- Category 81
- Category 129
- Category 152
- Category 166
- Category 174
- OTBI
- SQL
- BI Publisher
- OBIEE Answers
- Business Intelligence
- BI Publisher Reports
- Order Management
- Inventory
- Supply Chain Collaboration
- Supply Chain Planning
- Supply Chain Common Components
- Reporting and Analytics
- Sample Reports
- Tip
- SCM
- BI Cloud Connector
- Category 169-2
- Category 174-2
2