APPS.WIP_VALIDATEMLHEADER_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1544: from bom_operational_routings bor

1540: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1541: and wjsi.alternate_routing_designator <> fnd_api.g_miss_char
1542: and ( (wjsi.alternate_routing_designator is not null
1543: and not exists (select 1
1544: from bom_operational_routings bor
1545: where bor.alternate_routing_designator = wjsi.alternate_routing_designator
1546: and bor.organization_id = wjsi.organization_id
1547: and bor.assembly_item_id = decode(wjsi.load_type,
1548: wip_constants.create_ns_job, wjsi.routing_reference_id,

Line 2099: from bom_operational_routings bor

2095: wip_constants.op_pull))
2096: or (wjsi.wip_supply_type = wip_constants.op_pull and
2097: not exists
2098: (select 1
2099: from bom_operational_routings bor
2100: where bor.organization_id = wjsi.organization_id
2101: and bor.assembly_item_id = decode(wjsi.load_type,
2102: wip_constants.create_ns_job, wjsi.routing_reference_id,
2103: wjsi.primary_item_id)

Line 2599: from bom_operational_routings bor

2595:
2596: update wip_job_schedule_interface wjsi
2597: set wjsi.completion_subinventory =
2598: (select bor.completion_subinventory
2599: from bom_operational_routings bor
2600: where bor.organization_id = wjsi.organization_id
2601: and nvl(bor.cfm_routing_flag,2) = 2
2602: and bor.assembly_item_id = wjsi.primary_item_id
2603: and nvl(bor.alternate_routing_designator,'@@@') =

Line 2669: from bom_operational_routings bor

2665:
2666: update wip_job_schedule_interface wjsi
2667: set wjsi.completion_locator_id =
2668: (select bor.completion_locator_id
2669: from bom_operational_routings bor
2670: where bor.organization_id = wjsi.organization_id
2671: and nvl(bor.cfm_routing_flag, 2) = 2
2672: and bor.assembly_item_id = wjsi.primary_item_id
2673: and nvl(bor.alternate_routing_designator,'@@@') =

Line 3356: from bom_operational_routings

3352: else
3353: if(wjsi_row.load_type = wip_constants.create_ns_job and wjsi_row.routing_reference_id is not null) then
3354: select count(*)
3355: into l_rtgCount
3356: from bom_operational_routings
3357: where assembly_item_id = wjsi_row.routing_reference_id
3358: and organization_id = wjsi_row.organization_id
3359: and nvl(alternate_routing_designator, '@@@') =
3360: nvl(wjsi_row.alternate_routing_designator, '@@@')

Line 3366: from bom_operational_routings

3362: l_qty := wjsi_row.start_quantity;
3363: elsif(wjsi_row.load_type = wip_constants.create_job) then
3364: select count(*)
3365: into l_rtgCount
3366: from bom_operational_routings
3367: where assembly_item_id = wjsi_row.primary_item_id
3368: and organization_id = wjsi_row.organization_id
3369: and nvl(alternate_routing_designator, '@@@') =
3370: nvl(wjsi_row.alternate_routing_designator, '@@@')

Line 3735: from bom_operational_routings

3731: wip_logger.log('ENTERED into Validate routing revision',l_ret_status);
3732:
3733: select count(*)
3734: into l_count
3735: from bom_operational_routings
3736: where assembly_item_id = decode(wjsi_row.load_type,
3737: wip_constants.create_ns_job, wjsi_row.routing_reference_id,
3738: wjsi_row.primary_item_id
3739: )

Line 4179: from bom_operational_routings bor,

4175: end if;
4176:
4177: select count(*)
4178: into l_rtgCount
4179: from bom_operational_routings bor,
4180: wip_repetitive_items wri
4181: where wri.line_id = wjsi_row.line_id
4182: and nvl(bor.cfm_routing_flag, 2) = 2 --ignore flow rtgs
4183: and wri.primary_item_id = wjsi_row.primary_item_id

Line 4196: from bom_operational_routings bor,

4192: end if;
4193:
4194: select count(*)
4195: into l_rtgCount
4196: from bom_operational_routings bor,
4197: wip_repetitive_items wri
4198: where wri.line_id = wjsi_row.line_id
4199: and nvl(bor.cfm_routing_flag,2) = 2 --ignore flow routings
4200: and wri.primary_item_id = wjsi_row.primary_item_id