APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSH_NEW_DELIVERIES

Line 7834: from wsh_new_deliveries wds

7830: l_user,
7831: l_user,
7832: sysdate,
7833: sysdate
7834: from wsh_new_deliveries wds
7835: where wds.delivery_id = v_wlji_delivery_id(v_idx)
7836: and not exists (
7837: select 1
7838: from wip_schedule_groups wsg

Line 7847: wsh_new_deliveries wds

7843: wsg.schedule_group_id
7844: into v_wlji_schedule_group_name(v_idx),
7845: v_wlji_schedule_group_id(v_idx)
7846: from wip_schedule_groups wsg,
7847: wsh_new_deliveries wds
7848: where wds.delivery_id = v_wlji_delivery_id(v_idx)
7849: and wsg.schedule_group_name = wds.name
7850: and wsg.organization_id = v_wlji_org_id(v_idx);
7851: end if;