DBA Data[Home] [Help]

APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_ENTITIES

Line 2949: wip_entities we

2945: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
2946: nvl(we.organization_id, wjsi.organization_id) organization_id
2947: FROM wip_job_dtls_interface wjdi,
2948: wip_job_schedule_interface wjsi,
2949: wip_entities we
2950: WHERE wjdi.group_id = p_group_id
2951: AND wjsi.group_id = p_group_id
2952: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
2953: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

Line 3010: wip_entities we

3006: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
3007: nvl(we.organization_id, wjsi.organization_id) organization_id
3008: FROM wip_job_dtls_interface wjdi,
3009: wip_job_schedule_interface wjsi,
3010: wip_entities we
3011: WHERE wjdi.group_id = p_group_id
3012: AND wjsi.group_id = p_group_id
3013: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
3014: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)

Line 3083: wip_entities we

3079: nvl(we.primary_item_id, wjsi.primary_item_id) primary_item_id,
3080: nvl(we.organization_id, wjsi.organization_id) organization_id
3081: FROM wip_job_dtls_interface wjdi,
3082: wip_job_schedule_interface wjsi,
3083: wip_entities we
3084: WHERE wjdi.group_id = p_group_id
3085: AND wjsi.group_id = p_group_id
3086: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
3087: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)