DBA Data[Home] [Help]

APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_ENTITIES

Line 2823: wip_entities we

2819: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2820: nvl(we.organization_id, wjsi.organization_id) organization_id
2821: FROM wip_job_dtls_interface wjdi,
2822: wip_job_schedule_interface wjsi,
2823: wip_entities we
2824: WHERE wjdi.group_id = p_group_id
2825: AND wjsi.group_id = p_group_id
2826: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2827: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

Line 2884: wip_entities we

2880: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2881: nvl(we.organization_id, wjsi.organization_id) organization_id
2882: FROM wip_job_dtls_interface wjdi,
2883: wip_job_schedule_interface wjsi,
2884: wip_entities we
2885: WHERE wjdi.group_id = p_group_id
2886: AND wjsi.group_id = p_group_id
2887: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2888: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

Line 2957: wip_entities we

2953: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2954: nvl(we.organization_id, wjsi.organization_id) organization_id
2955: FROM wip_job_dtls_interface wjdi,
2956: wip_job_schedule_interface wjsi,
2957: wip_entities we
2958: WHERE wjdi.group_id = p_group_id
2959: AND wjsi.group_id = p_group_id
2960: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2961: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)