DBA Data[Home] [Help]

APPS.WIP_SERIAL_ASSOC_VALIDATIONS dependencies on WIP_DISCRETE_JOBS

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

Line 633: from wip_discrete_jobs wdj

629: and organization_id = p_organization_id
630: and wjdi.substitution_type = p_substitution_type
631: and wjdi.load_type = wip_job_details.wip_serial
632: and not exists (select 1
633: from wip_discrete_jobs wdj
634: where wjdi.wip_entity_id = wdj.wip_entity_id
635: and wdj.serialization_start_op is not null
636: and wdj.status_type in (wip_constants.unreleased,
637: wip_constants.released,