E1: 41: New Application that Allows a Join View of F41181 and F4118
Last updated on AUGUST 08, 2017
Applies to:JD Edwards EnterpriseOne Inventory Management - Version 9.1 and later
Information in this document applies to any platform.
Container Management standard has two basic applications: Container Transactions (P41181) and Billings Consultation Container (P4118).
The P41181 allows consult all shipments and pallets returns have been made with each client (F41181 table).
The application P4118 allows us to see all the billings of pallets which have made to a customer (F4118).
The business, in order to know the total debt of a customer has to consult both tables so; Customer is requesting a new application, to have in a single query all the transactions of every container for a particular customer or parent company (inputs, outputs and billings).
This application would allow users to consult these two tables (F41181, F4118) simultaneously
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms