DBA Data[Home] [Help]

APPS.WIP_SERIAL_ASSOC_VALIDATIONS dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 529: from wip_job_schedule_interface wjsi

525: and wjdi.organization_id = p_organization_id
526: and wjdi.substitution_type = p_substitution_type
527: and wjdi.load_type = wip_job_details.wip_serial
528: and not exists (select 1
529: from wip_job_schedule_interface wjsi
530: where wjsi.header_id = wjdi.parent_header_id
531: and wjsi.group_id = wjdi.group_id
532: and wjsi.load_type in (wip_constants.create_job,
533: wip_constants.create_ns_job,

Line 566: from wip_job_schedule_interface wjsi

562: and organization_id = p_organization_id
563: and wjdi.substitution_type = p_substitution_type
564: and wjdi.load_type = wip_job_details.wip_serial
565: and not exists (select 1
566: from wip_job_schedule_interface wjsi
567: where wjsi.header_id = wjdi.parent_header_id
568: and wjsi.group_id = wjdi.group_id
569: and wjsi.load_type in (wip_constants.create_job,
570: wip_constants.create_ns_job,

Line 593: from wip_job_schedule_interface wjsi, wip_discrete_jobs wdj

589: and wjdi.organization_id = p_organization_id
590: and wjdi.substitution_type = p_substitution_type
591: and wjdi.load_type = wip_job_details.wip_serial
592: and not exists (select 1
593: from wip_job_schedule_interface wjsi, wip_discrete_jobs wdj
594: where wjsi.header_id = wjdi.parent_header_id
595: and wjsi.group_id = wjdi.group_id
596: and wjsi.wip_entity_id = wdj.wip_entity_id
597: and wdj.serialization_start_op is not null