DBA Data[Home] [Help]

APPS.INVIDIT3 dependencies on WSH_DELIVERY_DETAILS

Line 916: from wsh_delivery_details wdd

912: IF (X_so_ship = 0) THEN
913: IF (shipping_level = 0) THEN
914: select count(1) into X_so_ship -- bug 10405137
915:
916: from wsh_delivery_details wdd
917: where wdd.inventory_item_id = p_item_id
918: and wdd.inv_interfaced_flag in ('N','P')
919: -- Bug 3963689 Condition added so that if no sales order and on hand qty 0
920: --then shippable flag of the item can be modified - Anmurali

Line 927: from wsh_delivery_details wdd

923: and wdd.organization_id = p_org_id
924: and rownum = 1;
925: ELSE
926: select count(1) into X_so_ship -- bug 10405137
927: from wsh_delivery_details wdd
928: where wdd.inventory_item_id = p_item_id
929: and wdd.inv_interfaced_flag in ('N','P')
930: -- Bug 3963689 Condition added so that if no sales order and on hand qty 0
931: --then shippable flag of the item can be modified - Anmurali