Question

Define Storage Volume Requirement

  • 27 April 2024
  • 3 replies
  • 29 views

Userlevel 4
Badge +9
  • Sidekick (Customer)
  • 58 replies

Hello,

I am looking for the table view which stores the information entered on this prompt so that I can see the part data. Can anyone help? thanks.

 

 


3 replies

Userlevel 1
Badge +5

Hi @mmoss  use select queery to fetch the data from table. 

 

Select * From NVENTORY_PART where part_no = ‘  ’

Run the query on SQL Query tool or PLSQL.

 

Thanks & Regards,

Zuhaib
IFS Consultant
https://www.linkedin.com/feed/

Userlevel 4
Badge +9

@zuhaib The records are stored per part/location combination so it cannot be in inventory_part. 

Userlevel 4
Badge +9

Nevermind, I can see it that the functionality is not as described and the location is purely to assist in calculating the ratio for a part for a given site.

Reply