APPS.WIP_FLOWUTIL_PRIV dependencies on BOM_OPERATION_SEQUENCES

Line 2506: from bom_operation_sequences bos,

2502: if ( p_routingSeqID is null ) then
2503: -- line op doesn't have effectivity date
2504: select distinct bos.operation_sequence_id
2505: into l_opSeqID
2506: from bom_operation_sequences bos,
2507: bom_operational_routings bor
2508: where bor.common_routing_sequence_id = bos.routing_sequence_id
2509: and bor.assembly_item_id = p_assyItemID
2510: and bor.organization_id = p_orgID

Line 2518: from bom_operation_sequences bos,

2514: and bos.operation_type = 3;
2515: else
2516: select distinct bos.operation_sequence_id
2517: into l_opSeqID
2518: from bom_operation_sequences bos,
2519: bom_operational_routings bor
2520: where bor.common_routing_sequence_id = bos.routing_sequence_id
2521: and bor.common_routing_sequence_id = p_routingSeqID
2522: and bos.operation_seq_num = p_terminalOpSeqNum

Line 2571: from bom_operation_sequences bos1,

2567: l_count number;
2568: begin
2569: select distinct bos2.operation_seq_num
2570: into l_evtLineOp
2571: from bom_operation_sequences bos1,
2572: bom_operation_sequences bos2
2573: where bos1.routing_sequence_id = bos2.routing_sequence_id
2574: and bos1.routing_sequence_id = p_routingSeqID
2575: and bos1.operation_seq_num = p_eventNum

Line 2572: bom_operation_sequences bos2

2568: begin
2569: select distinct bos2.operation_seq_num
2570: into l_evtLineOp
2571: from bom_operation_sequences bos1,
2572: bom_operation_sequences bos2
2573: where bos1.routing_sequence_id = bos2.routing_sequence_id
2574: and bos1.routing_sequence_id = p_routingSeqID
2575: and bos1.operation_seq_num = p_eventNum
2576: and bos1.operation_type = 1 -- event