Skip to main content
Question

Define Storage Volume Requirement

  • April 26, 2024
  • 3 replies
  • 73 views

Forum|alt.badge.img+10
  • Hero (Customer)
  • 77 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

zuhaib
Sidekick (Customer)
Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 78 replies
  • April 29, 2024

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/


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 77 replies
  • April 29, 2024

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


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • 77 replies
  • April 29, 2024

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.