DBA Data[Home] [Help]

APPS.WIP_JSI_VALIDATOR dependencies on WIP_REPETITIVE_ITEMS

Line 1080: from wip_repetitive_items

1076: if(wjsi_row.load_type = wip_constants.create_sched) then
1077: l_msg := 'WIP_ML_REPETITIVE_ITEM';
1078: select 1
1079: into g_dummy
1080: from wip_repetitive_items
1081: where line_id = wjsi_row.line_id
1082: and primary_item_id = wjsi_row.primary_item_id
1083: and organization_id = wjsi_row.organization_id;
1084: end if;

Line 1486: from bom_operational_routings bor, wip_repetitive_items wri

1482: raise fnd_api.g_exc_unexpected_error;
1483: end if;
1484: select count(*)
1485: into l_rtg_count
1486: from bom_operational_routings bor, wip_repetitive_items wri
1487: where wri.line_id = wjsi_row.line_id
1488: and nvl(bor.cfm_routing_flag, 2) = 2 --ignore flow rtgs
1489: and wri.primary_item_id = wjsi_row.primary_item_id
1490: and wri.organization_id = wjsi_row.organization_id

Line 1502: from bom_operational_routings bor, wip_repetitive_items wri

1498: end if;
1499:
1500: select count(*)
1501: into l_rtg_count
1502: from bom_operational_routings bor, wip_repetitive_items wri
1503: where wri.line_id = wjsi_row.line_id
1504: and nvl(bor.cfm_routing_flag,2) = 2 --ignore flow routings
1505: and wri.primary_item_id = wjsi_row.primary_item_id
1506: and wri.organization_id = wjsi_row.organization_id