APPS.WIP_JSI_VALIDATOR dependencies on WIP_LINES

Line 814: from wip_lines_val_v

810: raise fnd_api.g_exc_unexpected_error;
811: elsif(wjsi_row.line_id is not null) then
812: select 1
813: into g_dummy
814: from wip_lines_val_v
815: where line_id = wjsi_row.line_id
816: and organization_id = wjsi_row.organization_id;
817: end if;
818: exception

Line 1040: from wip_lines_val_v

1036: end if;
1037:
1038: select daily_maximum_rate
1039: into l_max_line_rate
1040: from wip_lines_val_v
1041: where line_id = wjsi_row.line_id;
1042:
1043: if(l_max_line_rate < wjsi_row.daily_production_rate) then
1044: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');

Line 1476: from wip_lines

1472: if(l_date_count <> 1) then
1473: --if you do not enter exactly one date then...
1474: select count(*)
1475: into l_line_count
1476: from wip_lines
1477: where organization_id = wjsi_row.organization_id
1478: and line_id = wjsi_row.line_id
1479: and line_schedule_type = 1; --fixed
1480: if(l_line_count > 0) then

Line 1513: from wip_lines_val_v

1509: and bor.assembly_item_id = wri.primary_item_id;
1510:
1511: select count(*)
1512: into l_line_count
1513: from wip_lines_val_v
1514: where organization_id = wjsi_row.organization_id
1515: and line_id = wjsi_row.line_id
1516: and line_schedule_type = 2;
1517: