Hi,
What is the replacement view for the SHIPMENT_HANDLING_UTILITY in cloud? I cannot find this view or a close view to this in cloud database.
Thanks
Roshanga
Solved
SHIPMENT_HANDLING_UTILITY
Best answer by Tomas Ruderfelt
Use view SHPMNT_HANDL_UNIT_WITH_HISTORY, it shows information regardless of status of the shipment in APP10 and IFS Cloud.
In the upgrade the two tablesshipment_handling_unit_tab and shipment_package_unit_tab, involved in the old view SHIPMENT_HANDLING_UTILITY are transferred to shipment_line_handl_unit_tab.
package_unit_id => handling_unit_id
pallet_type => handling_unit_type_id (from shipment_handling_unit_tab)
package_type => handling_unit_type_id (from shipment_package_unit_tab)
handling_unit_weight => operative_gross_weight
There is a STD report called SHIPMENT_PACKING_LIST_REP which shows the handling units if you want to see how it looks.
This topic has been closed for replies.
Shipment is rebuilt in APPS10 an onwards.
View for handling unit structure in shipment: HANDLING_UNIT_SHIPMENT
View for shipment lines connected to handling units in shipment: SHIPMENT_LINE_HANDL_UNIT_RES
There are more changes so what do you want to do?
Hi Tomas,
Thanks. Actually, I have a report using SHIPMENT_HANDLING_UTILITY in app 7.5 and i want to use this report in cloud as well. But unfortunately the columns package_unit__id, package_type, pallet_type, handling_unit_weight does not exists in none of the views. These fields are required to appear in the report and kindly let me know if these field names have been changed now and what are the fields i can use for them in cloud.
Thanks
Roshanga
Use view SHPMNT_HANDL_UNIT_WITH_HISTORY, it shows information regardless of status of the shipment in APP10 and IFS Cloud.
In the upgrade the two tablesshipment_handling_unit_tab and shipment_package_unit_tab, involved in the old view SHIPMENT_HANDLING_UTILITY are transferred to shipment_line_handl_unit_tab.
package_unit_id => handling_unit_id
pallet_type => handling_unit_type_id (from shipment_handling_unit_tab)
package_type => handling_unit_type_id (from shipment_package_unit_tab)
handling_unit_weight => operative_gross_weight
There is a STD report called SHIPMENT_PACKING_LIST_REP which shows the handling units if you want to see how it looks.
Use view SHPMNT_HANDL_UNIT_WITH_HISTORY, it shows information regardless of status of the shipment in APP10 and IFS Cloud.
In the upgrade the two tablesshipment_handling_unit_tab and shipment_package_unit_tab, involved in the old view SHIPMENT_HANDLING_UTILITY are transferred to shipment_line_handl_unit_tab.
package_unit_id => handling_unit_id
pallet_type => handling_unit_type_id (from shipment_handling_unit_tab)
package_type => handling_unit_type_id (from shipment_package_unit_tab)
handling_unit_weight => operative_gross_weight
There is a STD report called SHIPMENT_PACKING_LIST_REP which shows the handling units if you want to see how it looks.
Excellent. Thanks Tomas
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.