[Home] [Help]
1542: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1543: and wjsi.alternate_routing_designator <> fnd_api.g_miss_char
1544: and ( (wjsi.alternate_routing_designator is not null
1545: and not exists (select 1
1546: from bom_operational_routings bor
1547: where bor.alternate_routing_designator = wjsi.alternate_routing_designator
1548: and bor.organization_id = wjsi.organization_id
1549: and bor.assembly_item_id = decode(wjsi.load_type,
1550: wip_constants.create_ns_job, wjsi.routing_reference_id,
2097: wip_constants.op_pull))
2098: or (wjsi.wip_supply_type = wip_constants.op_pull and
2099: not exists
2100: (select 1
2101: from bom_operational_routings bor
2102: where bor.organization_id = wjsi.organization_id
2103: and bor.assembly_item_id = decode(wjsi.load_type,
2104: wip_constants.create_ns_job, wjsi.routing_reference_id,
2105: wjsi.primary_item_id)
2600:
2601: update wip_job_schedule_interface wjsi
2602: set wjsi.completion_subinventory =
2603: (select bor.completion_subinventory
2604: from bom_operational_routings bor
2605: where bor.organization_id = wjsi.organization_id
2606: and nvl(bor.cfm_routing_flag,2) = 2
2607: and bor.assembly_item_id = Decode(wjsi.load_type,
2608: wip_constants.create_job,
2675:
2676: update wip_job_schedule_interface wjsi
2677: set wjsi.completion_locator_id =
2678: (select bor.completion_locator_id
2679: from bom_operational_routings bor
2680: where bor.organization_id = wjsi.organization_id
2681: and nvl(bor.cfm_routing_flag, 2) = 2
2682: and bor.assembly_item_id = Decode(wjsi.load_type,
2683: wip_constants.create_job,
3382: else
3383: if(wjsi_row.load_type = wip_constants.create_ns_job and wjsi_row.routing_reference_id is not null) then
3384: select count(*)
3385: into l_rtgCount
3386: from bom_operational_routings
3387: where assembly_item_id = wjsi_row.routing_reference_id
3388: and organization_id = wjsi_row.organization_id
3389: and nvl(alternate_routing_designator, '@@@') =
3390: nvl(wjsi_row.alternate_routing_designator, '@@@')
3392: l_qty := wjsi_row.start_quantity;
3393: elsif(wjsi_row.load_type = wip_constants.create_job) then
3394: select count(*)
3395: into l_rtgCount
3396: from bom_operational_routings
3397: where assembly_item_id = wjsi_row.primary_item_id
3398: and organization_id = wjsi_row.organization_id
3399: and nvl(alternate_routing_designator, '@@@') =
3400: nvl(wjsi_row.alternate_routing_designator, '@@@')
3410: where wip_entity_id = wjsi_row.wip_entity_id;
3411: else
3412: select count(*)
3413: into l_rtgCount
3414: from bom_operational_routings
3415: where organization_id = wjsi_row.organization_id
3416: and assembly_item_id = nvl(wjsi_row.routing_reference_id,wjsi_row.primary_item_id)
3417: and nvl(alternate_routing_designator, '@@@^@@@') = nvl(wjsi_row.alternate_routing_designator, '@@@^@@@')
3418: and nvl(cfm_routing_flag, 2) = 2;
3837: wip_logger.log('ENTERED into Validate routing revision',l_ret_status);
3838:
3839: select count(*)
3840: into l_count
3841: from bom_operational_routings
3842: where assembly_item_id = decode(wjsi_row.load_type,
3843: wip_constants.create_ns_job, wjsi_row.routing_reference_id,
3844: wjsi_row.primary_item_id
3845: )
4304: end if;
4305:
4306: select count(*)
4307: into l_rtgCount
4308: from bom_operational_routings bor,
4309: wip_repetitive_items wri
4310: where wri.line_id = wjsi_row.line_id
4311: and nvl(bor.cfm_routing_flag, 2) = 2 --ignore flow rtgs
4312: and wri.primary_item_id = wjsi_row.primary_item_id
4321: end if;
4322:
4323: select count(*)
4324: into l_rtgCount
4325: from bom_operational_routings bor,
4326: wip_repetitive_items wri
4327: where wri.line_id = wjsi_row.line_id
4328: and nvl(bor.cfm_routing_flag,2) = 2 --ignore flow routings
4329: and wri.primary_item_id = wjsi_row.primary_item_id