XXWSH_PACKING_WORKBENCH_DELIVERY_SEARCH

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