APPS.WIP_FLOWUTIL_PRIV dependencies on BOM_OPERATION_SEQUENCES

Line 2545: from bom_operation_sequences bos,

2541: if ( p_routingSeqID is null ) then
2542: -- line op doesn't have effectivity date
2543: select distinct bos.operation_sequence_id
2544: into l_opSeqID
2545: from bom_operation_sequences bos,
2546: bom_operational_routings bor
2547: where bor.common_routing_sequence_id = bos.routing_sequence_id
2548: and bor.assembly_item_id = p_assyItemID
2549: and bor.organization_id = p_orgID

Line 2557: from bom_operation_sequences bos,

2553: and bos.operation_type = 3;
2554: else
2555: select distinct bos.operation_sequence_id
2556: into l_opSeqID
2557: from bom_operation_sequences bos,
2558: bom_operational_routings bor
2559: where bor.common_routing_sequence_id = bos.routing_sequence_id
2560: and bor.common_routing_sequence_id = p_routingSeqID
2561: and bos.operation_seq_num = p_terminalOpSeqNum

Line 2610: from bom_operation_sequences bos1,

2606: l_count number;
2607: begin
2608: select distinct bos2.operation_seq_num
2609: into l_evtLineOp
2610: from bom_operation_sequences bos1,
2611: bom_operation_sequences bos2
2612: where bos1.routing_sequence_id = bos2.routing_sequence_id
2613: and bos1.routing_sequence_id = p_routingSeqID
2614: and bos1.operation_seq_num = p_eventNum

Line 2611: bom_operation_sequences bos2

2607: begin
2608: select distinct bos2.operation_seq_num
2609: into l_evtLineOp
2610: from bom_operation_sequences bos1,
2611: bom_operation_sequences bos2
2612: where bos1.routing_sequence_id = bos2.routing_sequence_id
2613: and bos1.routing_sequence_id = p_routingSeqID
2614: and bos1.operation_seq_num = p_eventNum
2615: and bos1.operation_type = 1 -- event