APPS.WIP_JSI_VALIDATOR dependencies on WIP_REPETITIVE_ITEMS

Line 1085: from wip_repetitive_items

1081: if(wjsi_row.load_type = wip_constants.create_sched) then
1082: l_msg := 'WIP_ML_REPETITIVE_ITEM';
1083: select 1
1084: into g_dummy
1085: from wip_repetitive_items
1086: where line_id = wjsi_row.line_id
1087: and primary_item_id = wjsi_row.primary_item_id
1088: and organization_id = wjsi_row.organization_id;
1089: end if;

Line 1491: from bom_operational_routings bor, wip_repetitive_items wri

1487: raise fnd_api.g_exc_unexpected_error;
1488: end if;
1489: select count(*)
1490: into l_rtg_count
1491: from bom_operational_routings bor, wip_repetitive_items wri
1492: where wri.line_id = wjsi_row.line_id
1493: and nvl(bor.cfm_routing_flag, 2) = 2 --ignore flow rtgs
1494: and wri.primary_item_id = wjsi_row.primary_item_id
1495: and wri.organization_id = wjsi_row.organization_id

Line 1507: from bom_operational_routings bor, wip_repetitive_items wri

1503: end if;
1504:
1505: select count(*)
1506: into l_rtg_count
1507: from bom_operational_routings bor, wip_repetitive_items wri
1508: where wri.line_id = wjsi_row.line_id
1509: and nvl(bor.cfm_routing_flag,2) = 2 --ignore flow routings
1510: and wri.primary_item_id = wjsi_row.primary_item_id
1511: and wri.organization_id = wjsi_row.organization_id