XXWSH_PACKING_WORKBENCH_DELIVERY_SEARCH

➜ Back to Library
Description
System report controlling the search functionality on the custom packing workbench form
Run XXWSH_PACKING_WORKBENCH_DELIVERY_SEARCH and other Oracle EBS reports with Blitz Report™ on our demo environment
insert into xxen_report_search_ids xrsi (rowid1)
select
wdd.rowid
from
wsh_delivery_details wdd
where
1=1 and
(wdd.organization_id,wdd.inventory_item_id) in (select msib.organization_id, msib.inventory_item_id from mtl_system_items_b msib where msib.inventory_item_flag='Y') and
wdd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and
wdd.source_code='OE'
Parameter Name SQL text Validation
Sales Order 
wdd.source_header_id in (select ooh.header_id from oe_order_headers ooh where ooh.order_number=:order_number)
 LOV
Delivery Name 
wdd.delivery_detail_id in (
select
wda.delivery_detail_id
from
wsh_new_deliveries wnd,
wsh_delivery_assignments wda
where
wnd.name=:delivery_number and
wnd.delivery_id=wda.delivery_id
)
 LOV
Box Number 
wdd.delivery_detail_id in (select xpba.delivery_detail_id from xxwsh_packing_box_assignments xpba where xpba.box_id=substr(:box_number,instr(:box_number,'-')+1))
 LOV
Item 
(wdd.inventory_item_id,wdd.organization_id) in (select msib.inventory_item_id,msib.organization_id from mtl_system_items_b msib where msib.segment1=:item)
 LOV
Serial Number 
wdd.serial_number=:serial_number
 LOV
Sales Order (historic) 
wdd.source_header_id in (select ooh.header_id from oe_order_headers ooh where ooh.order_number=:order_number)
 LOV
Delivery Name (historic) 
wdd.delivery_detail_id in (
select
wda.delivery_detail_id
from
wsh_new_deliveries wnd,
wsh_delivery_assignments wda
where
wnd.name=:delivery_number and
wnd.delivery_id=wda.delivery_id
)
 LOV
Item (historic) 
(wdd.inventory_item_id,wdd.organization_id) in (select msib.inventory_item_id,msib.organization_id from mtl_system_items_b msib where msib.segment1=:item)
 LOV
Download
Related Blitz Reports
Yanmar - Discount on order lines check ONT DIFOT XXONT Orders and Lines ONT Orders and Lines FND Attached Documents XXWSH Packing Workbench Details PPF_WP3_OM_DETAILS XXEN_SCHUB_ITEM_SEARCH WSH Bill of Lading
Blitz Report™

Blitz Report™ provides multiple benefits: