ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 5C32A64D202006B4E0530100007F9428Y 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' S :Sales_Order is not null or :Delivery_Name is not null or :Box_Number is not null or :Item is not null or :Serial_Number is not null or :Sales_Order_historic is not null or :Delivery_Name_historic is not null or :Item_historic is not null US XXWSH_PACKING_WORKBENCH_DELIVERY_SEARCH System report controlling the search functionality on the custom packing workbench form 1=1 1 10 1=1 wdd.source_header_id in (select ooh.header_id from oe_order_headers ooh where ooh.order_number=:order_number) LOV custom Y select ooh.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooh.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers ooh, oe_transaction_types_tl ottt, hz_cust_accounts hca where (ooh.header_id,ooh.org_id) in ( select wdd.source_header_id, wdd.org_id from wsh_delivery_details wdd where wdd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and wdd.source_code='OE' and wdd.released_status in ('Y','B','R','S') ) and ooh.open_flag='Y' and ooh.sold_to_org_id=hca.cust_account_id and ooh.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooh.order_number desc D Auftrag US Sales Order 2 20 1=1 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 custom Y select wnd.name value, hca.account_name description from wsh_new_deliveries wnd, hz_cust_accounts hca where wnd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and wnd.customer_id=hca.cust_account_id(+) and nvl(wnd.shipment_direction,'O') in ('O','IO') and wnd.delivery_type='STANDARD' and wnd.status_code='OP' and wnd.delivery_id in (select wda.delivery_id from wsh_delivery_assignments wda, wsh_delivery_details wdd where wda.delivery_detail_id=wdd.delivery_detail_id and wdd.released_status in ('Y','B','R','S') and wdd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by wnd.delivery_id desc 3770374 D Lieferung US Delivery Name 3 30 1=1 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 custom Y select distinct mp.organization_code||'-'||xpba.box_id value, wnd.name description, xpba.box_id from mtl_parameters mp, xxwsh_packing_box_assignments xpba, wsh_delivery_assignments wda, wsh_new_deliveries wnd where xpba.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and mp.organization_id=xpba.organization_id and xpba.delivery_detail_id=wda.delivery_detail_id and wda.delivery_id=wnd.delivery_id order by xpba.box_id desc D Colli-Nummer US Box Number 4 40 1=1 (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 custom Y select distinct msiv.concatenated_segments value, msiv.description from wsh_delivery_details wdd, mtl_system_items_vl msiv where wdd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and wdd.released_status in ('Y','B','R','S') and wdd.inventory_item_id=msiv.inventory_item_id and wdd.organization_id=msiv.organization_id order by msiv.concatenated_segments D Artikel US Item 5 50 1=1 wdd.serial_number=:serial_number LOV custom Y select wdd.serial_number value, msiv.concatenated_segments||': '||msiv.description description, wdd.delivery_detail_id from wsh_delivery_details wdd, mtl_system_items_vl msiv where wdd.serial_number is not null and wdd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and wdd.released_status in ('Y','B','R','S') and wdd.organization_id=msiv.organization_id(+) and wdd.inventory_item_id=msiv.inventory_item_id(+) order by wdd.delivery_detail_id desc D Seriennummer US Serial Number 6 60 1=1 wdd.source_header_id in (select ooh.header_id from oe_order_headers ooh where ooh.order_number=:order_number) LOV custom Y Y select ooh.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooh.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers ooh, oe_transaction_types_tl ottt, hz_cust_accounts hca where (ooh.header_id,ooh.org_id) in ( select wdd.source_header_id, wdd.org_id from wsh_delivery_details wdd where wdd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and wdd.source_code='OE' ) and ooh.sold_to_org_id=hca.cust_account_id and ooh.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooh.order_number desc D Auftrag (historisch) US Sales Order (historic) 7 70 1=1 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 custom Y Y select wnd.name value, hca.account_name description from wsh_new_deliveries wnd, hz_cust_accounts hca where wnd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and wnd.customer_id=hca.cust_account_id(+) and nvl(wnd.shipment_direction,'O') in ('O','IO') and wnd.delivery_type='STANDARD' order by wnd.delivery_id desc D Lieferung (historisch) US Delivery Name (historic) 8 80 1=1 (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 custom Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') D Artikel (historisch) US Item (historic)