APPS.INVIDIT3 dependencies on WSH_DELIVERY_DETAILS

Line 832: from wsh_delivery_details wdd

828: end if;
829: exception when no_data_found then
830: begin
831: select 1 into X_so_ship
832: from wsh_delivery_details wdd
833: where wdd.inventory_item_id = p_item_id
834: and wdd.inv_interfaced_flag in ('N','P')
835: -- Bug 3963689 Condition added so that if no sales order and on hand qty 0
836: --then shippable flag of the item can be modified - Anmurali

Line 849: from wsh_delivery_details wdd

845: where master_organization_id = p_master_org)
846: loop
847: begin
848: select 1 into X_so_ship
849: from wsh_delivery_details wdd
850: where wdd.inventory_item_id = p_item_id
851: and wdd.inv_interfaced_flag in ('N','P')
852: -- Bug 3963689 Condition added so that if no sales order and on hand qty 0
853: --then shippable flag of the item can be modified - Anmurali