APPS.WIP_JSI_VALIDATOR dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1200: from bom_operational_routings

1196: raise fnd_api.g_exc_unexpected_error;
1197: elsif(wjsi_row.wip_supply_type = wip_constants.op_pull) then
1198: select count(*)
1199: into l_routing_count
1200: from bom_operational_routings
1201: where organization_id = wjsi_row.organization_id
1202: and assembly_item_id = decode(wjsi_row.load_type, wip_constants.create_ns_job, wjsi_row.routing_reference_id, wjsi_row.primary_item_id)
1203: and nvl(alternate_routing_designator, '@@@') = nvl(wjsi_row.alternate_routing_designator, '@@@')
1204: and nvl(cfm_routing_flag, 2) = 2; --ignore flow routings

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

Line 2208: from bom_operational_routings

2204: else
2205: if(wjsi_row.load_type = wip_constants.create_ns_job and wjsi_row.routing_reference_id is not null) then
2206: select count(*)
2207: into l_rtg_count
2208: from bom_operational_routings
2209: where assembly_item_id = wjsi_row.routing_reference_id
2210: and organization_id = wjsi_row.organization_id
2211: and nvl(alternate_routing_designator, '@@') = nvl(wjsi_row.alternate_routing_designator, '@@')
2212: and nvl(cfm_routing_flag, 2) = 2;

Line 2217: from bom_operational_routings

2213: l_qty := wjsi_row.start_quantity;
2214: elsif(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then
2215: select count(*)
2216: into l_rtg_count
2217: from bom_operational_routings
2218: where assembly_item_id = wjsi_row.primary_item_id
2219: and organization_id = wjsi_row.organization_id
2220: and nvl(alternate_routing_designator, '@@') = nvl(wjsi_row.alternate_routing_designator, '@@')
2221: and nvl(cfm_routing_flag, 2) = 2;

Line 2332: from bom_operational_routings

2328: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
2329: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
2330: select count(*)
2331: into l_count
2332: from bom_operational_routings
2333: where assembly_item_id = decode(wjsi_row.load_type, wip_constants.create_ns_job, wjsi_row.routing_reference_id,
2334: wjsi_row.primary_item_id)
2335: and organization_id = wjsi_row.organization_id
2336: and nvl(alternate_routing_designator, '@@') = nvl(wjsi_row.alternate_routing_designator, '@@');