DBA Data[Home] [Help]

APPS.WSM_WLT_VALIDATE_PVT dependencies on BOM_OPERATION_NETWORKS

Line 7983: from bom_operation_networks bon,

7979: select 1
7980: into l_primary
7981: from dual
7982: where 1 in ( select 1
7983: from bom_operation_networks bon,
7984: bom_operation_sequences bos
7985: where bon.transition_type = 1 -- Primary
7986: and nvl(bon.disable_date, sysdate+1) > p_revision_date -- or is it sysdate
7987: -- Start : Fix for bug 4494368/4576184 --

Line 7999: from bom_operation_networks bon,

7995:
7996: UNION
7997:
7998: select 1
7999: from bom_operation_networks bon,
8000: bom_operation_sequences bos
8001: -- Start : Fix for bug 4494368/4576184 --
8002: --where WSMPUTIL.replacement_op_seq_id(bon.to_op_seq_id,
8003: -- p_revision_date) = bos.operation_sequence_id

Line 8010: from bom_operation_networks bon1,

8006: -- End : Fix for bug 4494368/4576184 --
8007: and bos.routing_sequence_id = p_rtg_seq_id
8008: and bos.operation_seq_num = p_start_op_seq_num
8009: and bon.to_op_seq_id not in ( select bon1.from_op_seq_id
8010: from bom_operation_networks bon1,
8011: bom_operation_sequences bos1
8012: where WSMPUTIL.replacement_op_seq_id (
8013: bon1.from_op_seq_id,
8014: p_revision_date) = bos1.operation_sequence_id