DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WSH_NEW_DELIVERIES

Line 763: wsh_new_deliveries wds

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

Line 779: wsh_new_deliveries wds

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

Line 818: from wsh_new_deliveries wds,

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