APPS.WIP_FLOW_UTILITIES dependencies on BOM_OPERATION_SEQUENCES

Line 1785: FROM bom_operation_sequences

1781: IF (p_terminal_op_seq_num IS NULL
1782: AND Nvl(p_terminal_op_seq_id,-1) > 0) THEN
1783: SELECT operation_seq_num
1784: INTO l_terminal_op_seq_num
1785: FROM bom_operation_sequences
1786: WHERE routing_sequence_id = p_routing_sequence_id
1787: AND operation_sequence_id = p_terminal_op_seq_id;
1788: ELSIF p_terminal_op_seq_num IS NOT NULL THEN
1789: l_terminal_op_seq_num := p_terminal_op_seq_num;

Line 1933: FROM bom_operation_sequences

1929: IF p_line_op_seq2_id IS NULL
1930: AND p_line_op_seq2_num > 0 THEN
1931: SELECT operation_sequence_id
1932: INTO l_line_op_seq2_id
1933: FROM bom_operation_sequences
1934: WHERE routing_sequence_id = p_routing_sequence_id
1935: AND operation_seq_num = p_line_op_seq2_num
1936: AND operation_type = 3;
1937: ELSE

Line 1945: FROM bom_operation_sequences

1941: IF p_line_op_seq1_id IS NULL
1942: AND p_line_op_seq1_num > 0 THEN
1943: SELECT operation_sequence_id
1944: INTO l_line_op_seq1_id
1945: FROM bom_operation_sequences
1946: WHERE routing_sequence_id = p_routing_sequence_id
1947: AND operation_seq_num = p_line_op_seq1_num
1948: AND operation_type = 3;
1949: ELSE

Line 2018: FROM bom_operation_sequences

2014: IF p_line_op_seq2_id IS NULL
2015: AND p_line_op_seq2_num > 0 THEN
2016: SELECT operation_sequence_id
2017: INTO l_line_op_seq2_id
2018: FROM bom_operation_sequences
2019: WHERE routing_sequence_id = p_routing_sequence_id
2020: AND operation_seq_num = p_line_op_seq2_num
2021: AND operation_type = 3;
2022: ELSE

Line 2030: FROM bom_operation_sequences

2026: IF p_line_op_seq1_id IS NULL
2027: AND p_line_op_seq1_num > 0 THEN
2028: SELECT operation_sequence_id
2029: INTO l_line_op_seq1_id
2030: FROM bom_operation_sequences
2031: WHERE routing_sequence_id = p_routing_sequence_id
2032: AND operation_seq_num = p_line_op_seq1_num
2033: AND operation_type = 3;
2034: ELSE

Line 2079: FROM bom_operation_sequences bos1, bom_operation_sequences bos2

2075: BEGIN
2076:
2077: SELECT bos2.operation_seq_num, bos2.operation_sequence_id
2078: INTO l_line_op_seq_num, l_line_op_seq_id
2079: FROM bom_operation_sequences bos1, bom_operation_sequences bos2
2080: WHERE bos2.operation_sequence_id = bos1.line_op_seq_id
2081: AND bos1.routing_sequence_id = p_routing_sequence_id
2082: AND bos1.operation_seq_num = p_event_op_seq_num
2083: AND bos1.effectivity_date <= p_eff_date