APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_LINES_VAL_V

Line 886: from wip_lines_val_v wl

882: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
883: and wjsi.line_code is not null
884: and wjsi.line_id is null
885: and not exists (select 1
886: from wip_lines_val_v wl
887: where wl.line_code = wjsi.line_code
888: and wl.organization_id = wjsi.organization_id)
889: returning wjsi.interface_id bulk collect into l_interfaceTbl;
890:

Line 916: from wip_lines_val_v wl

912: end if;
913:
914: update wip_job_schedule_interface wjsi
915: set line_id = (select wl.line_id
916: from wip_lines_val_v wl
917: where wl.line_code = wjsi.line_code
918: and wl.organization_id = wjsi.organization_id),
919: last_update_date = sysdate
920: where wjsi.group_id = p_groupID

Line 936: from wip_lines_val_v wl

932: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
933: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
934: and wjsi.line_id is not null
935: and not exists (select 1
936: from wip_lines_val_v wl
937: where wl.line_id = wjsi.line_id
938: and wl.organization_id = wjsi.organization_id)
939: returning wjsi.interface_id bulk collect into l_interfaceTbl;
940:

Line 4252: from wip_lines_val_v

4248: end if;
4249:
4250: select daily_maximum_rate
4251: into l_maxLineRate
4252: from wip_lines_val_v
4253: where line_id = wjsi_row.line_id;
4254:
4255: if( l_maxLineRate < wjsi_row.daily_production_rate ) then
4256: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');

Line 4337: from wip_lines_val_v

4333: and bor.assembly_item_id = wri.primary_item_id;
4334:
4335: select count(*)
4336: into l_lineCount
4337: from wip_lines_val_v
4338: where organization_id = wjsi_row.organization_id
4339: and line_id = wjsi_row.line_id
4340: and line_schedule_type = 2;
4341: