DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WSH_NEW_DELIVERIES

Line 761: wsh_new_deliveries wds

757: update wip_job_schedule_interface wjsi
758: set wjsi.schedule_group_id =
759: (select wsg.schedule_group_id
760: from wip_schedule_groups wsg,
761: wsh_new_deliveries wds
762: where wds.delivery_id = wjsi.delivery_id
763: and wsg.schedule_group_name = wds.name
764: and wsg.organization_id = wjsi.organization_id),
765: wjsi.last_update_date = sysdate

Line 777: wsh_new_deliveries wds

773: and wjsi.source_code = 'WICDOL'
774: and wjsi.delivery_id is not null
775: and exists (select wsg.schedule_group_id
776: from wip_schedule_groups wsg,
777: wsh_new_deliveries wds
778: where wds.delivery_id = wjsi.delivery_id
779: and wsg.schedule_group_name = wds.name
780: and wsg.organization_id = wjsi.organization_id);
781:

Line 816: from wsh_new_deliveries wds,

812: fnd_global.user_id,
813: fnd_global.user_id,
814: sysdate,
815: sysdate
816: from wsh_new_deliveries wds,
817: wip_job_schedule_interface wjsi
818: where wds.delivery_id = wjsi.delivery_id
819: and wjsi.interface_id = l_interfaceTbl(i);
820: