APPS.WIP_JSI_VALIDATOR dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1195: from bom_operational_routings

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

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

Line 2203: from bom_operational_routings

2199: else
2200: if(wjsi_row.load_type = wip_constants.create_ns_job and wjsi_row.routing_reference_id is not null) then
2201: select count(*)
2202: into l_rtg_count
2203: from bom_operational_routings
2204: where assembly_item_id = wjsi_row.routing_reference_id
2205: and organization_id = wjsi_row.organization_id
2206: and nvl(alternate_routing_designator, '@@') = nvl(wjsi_row.alternate_routing_designator, '@@')
2207: and nvl(cfm_routing_flag, 2) = 2;

Line 2212: from bom_operational_routings

2208: l_qty := wjsi_row.start_quantity;
2209: elsif(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_eam_job)) then
2210: select count(*)
2211: into l_rtg_count
2212: from bom_operational_routings
2213: where assembly_item_id = wjsi_row.primary_item_id
2214: and organization_id = wjsi_row.organization_id
2215: and nvl(alternate_routing_designator, '@@') = nvl(wjsi_row.alternate_routing_designator, '@@')
2216: and nvl(cfm_routing_flag, 2) = 2;

Line 2327: from bom_operational_routings

2323: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_sched,
2324: wip_constants.create_ns_job, wip_constants.create_eam_job)) then
2325: select count(*)
2326: into l_count
2327: from bom_operational_routings
2328: where assembly_item_id = decode(wjsi_row.load_type, wip_constants.create_ns_job, wjsi_row.routing_reference_id,
2329: wjsi_row.primary_item_id)
2330: and organization_id = wjsi_row.organization_id
2331: and nvl(alternate_routing_designator, '@@') = nvl(wjsi_row.alternate_routing_designator, '@@');