Hi @Ed22 ,

If you have oracle developer open, under the connection you should have a menu called “other users”.

Find the IFSAPP user and expand this, then you should be able to find the package you're looking for:

Thanks, I find it.

When I want to rewrite this sql in expression, how can I achieve this? SELECT a.QTY_RESERVED
FROM DETAIL_PLANNING a, because I cannot find DETAIL_PLANNING_API
 

Hi Ed, 

You're refering to a PL/SQL expression.

It might not exist, but I'm unsure in this case as I'm not familiar myself to regards of this view.

You don't HAVE to use PL/SQL statements. You can also use select queries which might also perform better than PL/SQL statements. You just need to know the keys and add the necessary criteria. 

Best thing to do is to check the entity as to which the keys are.

Hello, 

thanks for response. How can I find out this column, if this columns (qty_demand) is located in entity OrderSupplyDemandDetailPlanning and in view DETAIL_PLANNING? Should I look for the entity name in Packages folder? Like OrderSupplyDemandDetailPlanning_API or something like this?

In this case I used a query to find out the Entity. I can explain how you can find the entity, but from my end the view does not state which are the keys so it won't help you a lot there. 

In this case you will need to have some process knowledge and compare that with the view columns to determine what you need to retrieve a unique record.

Normally you'd go:

1. To the entity screen and look up the entity
2. Find the view
3. Look at the bottom for columns with P/K attribute.

However in this case I found that this is not set in this view. You could take a look at the base view to see what the keys are there and then compare with your specific view.