DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

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

1195:
1196: begin
1197: select a.routing_sequence_id
1198: into l_routing_seq_id
1199: from bom_operational_routings a, bom_operational_routings b, wip_flow_schedules wfs
1200: where a.routing_sequence_id = b.common_routing_sequence_id
1201: and b.assembly_item_id = wfs.primary_item_id
1202: and wfs.wip_entity_id = p_alloc_tbl(i).wip_entity_id
1203: and b.organization_id = wfs.organization_id

Line 1207: from bom_operational_routings c

1203: and b.organization_id = wfs.organization_id
1204: and ( nvl(b.alternate_routing_designator, 'none') = nvl(wfs.alternate_routing_designator, 'none')
1205: or ( b.alternate_routing_designator IS NULL
1206: and not exists(select 'x'
1207: from bom_operational_routings c
1208: where c.assembly_item_id = wfs.primary_item_id
1209: and c.organization_id = wfs.organization_id
1210: and c.alternate_routing_designator = wfs.alternate_routing_designator
1211: )