DBA Data[Home] [Help]

APPS.WIP_PICKING_PVT dependencies on BOM_OPERATION_SEQUENCES

Line 1337: FROM bom_operation_sequences bos1

1333: -- Get Line Op
1334: begin
1335: SELECT bos1.operation_seq_num
1336: into l_operationSeqNum
1337: FROM bom_operation_sequences bos1
1338: WHERE bos1.operation_sequence_id = (select bos2.line_op_seq_id from bom_operation_sequences bos2
1339: where bos2.routing_sequence_id = l_routing_seq_id
1340: and bos2.operation_seq_num = l_flowCompTbl(j).operation_seq_num
1341: and bos2.operation_type = 1 );

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

1334: begin
1335: SELECT bos1.operation_seq_num
1336: into l_operationSeqNum
1337: FROM bom_operation_sequences bos1
1338: WHERE bos1.operation_sequence_id = (select bos2.line_op_seq_id from bom_operation_sequences bos2
1339: where bos2.routing_sequence_id = l_routing_seq_id
1340: and bos2.operation_seq_num = l_flowCompTbl(j).operation_seq_num
1341: and bos2.operation_type = 1 );
1342: