DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on BOM_OPERATION_SEQUENCES

Line 1362: FROM bom_operation_sequences bos1

1358: -- Get Line Op
1359: begin
1360: SELECT bos1.operation_seq_num
1361: into l_operationSeqNum
1362: FROM bom_operation_sequences bos1
1363: WHERE bos1.operation_sequence_id = (select bos2.line_op_seq_id from bom_operation_sequences bos2
1364: where bos2.routing_sequence_id = l_routing_seq_id
1365: and bos2.operation_seq_num = l_flowCompTbl(j).operation_seq_num
1366: and bos2.operation_type = 1 );

Line 1363: WHERE bos1.operation_sequence_id = (select bos2.line_op_seq_id from bom_operation_sequences bos2

1359: begin
1360: SELECT bos1.operation_seq_num
1361: into l_operationSeqNum
1362: FROM bom_operation_sequences bos1
1363: WHERE bos1.operation_sequence_id = (select bos2.line_op_seq_id from bom_operation_sequences bos2
1364: where bos2.routing_sequence_id = l_routing_seq_id
1365: and bos2.operation_seq_num = l_flowCompTbl(j).operation_seq_num
1366: and bos2.operation_type = 1 );
1367: