DBA Data[Home] [Help]

APPS.FLM_KANBAN dependencies on BOM_OPERATION_SEQUENCES

Line 310: bom_operation_sequences bos1,

306: Select
307: bos2.standard_operation_id
308: From
309: bom_operational_routings bor,
310: bom_operation_sequences bos1,
311: bom_operation_sequences bos2
312: Where
313: bor.organization_id = p_org_id and
314: bor.assembly_item_id = p_assembly_item_id and

Line 311: bom_operation_sequences bos2

307: bos2.standard_operation_id
308: From
309: bom_operational_routings bor,
310: bom_operation_sequences bos1,
311: bom_operation_sequences bos2
312: Where
313: bor.organization_id = p_org_id and
314: bor.assembly_item_id = p_assembly_item_id and
315: nvl(bor.alternate_routing_designator,'NONE') = nvl(p_alt,'NONE') and

Line 329: bom_operation_sequences bos1,

325: Select
326: bos2.standard_operation_id
327: From
328: bom_operational_routings bor,
329: bom_operation_sequences bos1,
330: bom_operation_sequences bos2
331: Where
332: bor.organization_id = p_org_id and
333: bor.assembly_item_id = p_assembly_item_id and

Line 330: bom_operation_sequences bos2

326: bos2.standard_operation_id
327: From
328: bom_operational_routings bor,
329: bom_operation_sequences bos1,
330: bom_operation_sequences bos2
331: Where
332: bor.organization_id = p_org_id and
333: bor.assembly_item_id = p_assembly_item_id and
334: nvl(bor.alternate_routing_designator,'NONE') = nvl(p_alt,'NONE') and