DBA Data[Home] [Help]

APPS.WSMPLBJI dependencies on BOM_OPERATION_NETWORKS

Line 612: from bom_operation_networks

608: build_job_exception exception;
609:
610: cursor wsm_bon_cur is (
611: select from_op_seq_id "from_opseq_id", level
612: from bom_operation_networks
613: where transition_type = 1
614: start with to_op_seq_id = l_bon_seq_id1 and transition_type = 1
615: connect by to_op_seq_id = prior from_op_seq_id and transition_type = 1
616: union

Line 712: from bom_operation_sequences bos, bom_operation_networks bon

708: -- wsmputil.replacement_op_seq_id has been used to find the equivalent effective op-seq-id's. (abb)
709:
710: select unique(bos.operation_sequence_id)
711: into l_bon_seq_id1
712: from bom_operation_sequences bos, bom_operation_networks bon
713: where bos.operation_seq_num = l_rtg_op_seq_num
714: and bos.routing_sequence_id = l_common_routing_sequence_id
715: -- BA: CZH.OED-2, it may have a replacement
716: and (bos.operation_sequence_id = bon.from_op_seq_id