DBA Data[Home] [Help]

APPS.WIP_JSI_VALIDATOR dependencies on WIP_LINES_VAL_V

Line 819: from wip_lines_val_v

815: raise fnd_api.g_exc_unexpected_error;
816: elsif(wjsi_row.line_id is not null) then
817: select 1
818: into g_dummy
819: from wip_lines_val_v
820: where line_id = wjsi_row.line_id
821: and organization_id = wjsi_row.organization_id;
822: end if;
823: exception

Line 1045: from wip_lines_val_v

1041: end if;
1042:
1043: select daily_maximum_rate
1044: into l_max_line_rate
1045: from wip_lines_val_v
1046: where line_id = wjsi_row.line_id;
1047:
1048: if(l_max_line_rate < wjsi_row.daily_production_rate) then
1049: fnd_message.set_name('WIP', 'WIP_PROD_RATE_WARNING');

Line 1518: from wip_lines_val_v

1514: and bor.assembly_item_id = wri.primary_item_id;
1515:
1516: select count(*)
1517: into l_line_count
1518: from wip_lines_val_v
1519: where organization_id = wjsi_row.organization_id
1520: and line_id = wjsi_row.line_id
1521: and line_schedule_type = 2;
1522: