APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_LINES

Line 884: from wip_lines_val_v wl

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

Line 914: from wip_lines_val_v wl

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

Line 934: from wip_lines_val_v wl

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

Line 4123: from wip_lines_val_v

4119: end if;
4120:
4121: select daily_maximum_rate
4122: into l_maxLineRate
4123: from wip_lines_val_v
4124: where line_id = wjsi_row.line_id;
4125:
4126: if( l_maxLineRate < wjsi_row.daily_production_rate ) then
4127: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');

Line 4168: from wip_lines

4164:
4165: if ( l_dateCount <> 1 ) then
4166: select count(*)
4167: into l_lineCount
4168: from wip_lines
4169: where organization_id = wjsi_row.organization_id
4170: and line_id = wjsi_row.line_id
4171: and line_schedule_type = 1; --fixed
4172: if( l_lineCount > 0 ) then

Line 4208: from wip_lines_val_v

4204: and bor.assembly_item_id = wri.primary_item_id;
4205:
4206: select count(*)
4207: into l_lineCount
4208: from wip_lines_val_v
4209: where organization_id = wjsi_row.organization_id
4210: and line_id = wjsi_row.line_id
4211: and line_schedule_type = 2;
4212: