DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1174: from bom_operational_routings a, bom_operational_routings b, wip_flow_schedules wfs

1170:
1171: begin
1172: select a.routing_sequence_id
1173: into l_routing_seq_id
1174: from bom_operational_routings a, bom_operational_routings b, wip_flow_schedules wfs
1175: where a.routing_sequence_id = b.common_routing_sequence_id
1176: and b.assembly_item_id = wfs.primary_item_id
1177: and wfs.wip_entity_id = p_alloc_tbl(i).wip_entity_id
1178: and b.organization_id = wfs.organization_id

Line 1182: from bom_operational_routings c

1178: and b.organization_id = wfs.organization_id
1179: and ( nvl(b.alternate_routing_designator, 'none') = nvl(wfs.alternate_routing_designator, 'none')
1180: or ( b.alternate_routing_designator IS NULL
1181: and not exists(select 'x'
1182: from bom_operational_routings c
1183: where c.assembly_item_id = wfs.primary_item_id
1184: and c.organization_id = wfs.organization_id
1185: and c.alternate_routing_designator = wfs.alternate_routing_designator
1186: )