XXWSH_PACKING_WORKBENCH_DELIVERY_SEARCH

➜ Back to Library
Description
System report controlling the search functionality on the custom packing workbench form
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 NameSQL textValidation
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
CAC Interface Error Summary WSH Shipping/Delivery Transactions XXWSH Packing Workbench Details FND Attached Documents Mgt: Senfor Intl - Sales Order Book - Demand Planning Analysis ONT Orders and Lines PPF_WP3_OM_DETAILS Yanmar - Discount on order lines check ONT DIFOT
Blitz Report™