APPS.WSMPUTIL dependencies on BOM_OPERATION_NETWORKS_V

Line 1020: FROM BOM_OPERATION_NETWORKS_V

1016: BEGIN
1017:
1018: SELECT count(*)
1019: INTO p_count
1020: FROM BOM_OPERATION_NETWORKS_V
1021: WHERE routing_sequence_id = p_routing_sequence_id
1022: AND transition_type = 1
1023: AND from_op_seq_id NOT IN
1024: (SELECT to_op_seq_id

Line 1025: FROM BOM_OPERATION_NETWORKS_V

1021: WHERE routing_sequence_id = p_routing_sequence_id
1022: AND transition_type = 1
1023: AND from_op_seq_id NOT IN
1024: (SELECT to_op_seq_id
1025: FROM BOM_OPERATION_NETWORKS_V
1026: WHERE routing_sequence_id = p_routing_sequence_id
1027: AND transition_type = 1 );
1028:
1029: IF p_count > 1 THEN

Line 1045: FROM bom_operation_networks_v

1041:
1042: BEGIN
1043: SELECT to_op_seq_id, to_seq_num
1044: INTO x_temp,x_meet_num
1045: FROM bom_operation_networks_v
1046: WHERE from_op_seq_id = x_from_id
1047: AND transition_type = 1;
1048:
1049: EXCEPTION

Line 1077: FROM BOM_OPERATION_NETWORKS_V

1073:
1074: IF p_count > 1 THEN
1075: SELECT from_seq_num
1076: INTO x_meet_num
1077: FROM BOM_OPERATION_NETWORKS_V
1078: WHERE from_op_seq_id = x_from_id;
1079:
1080: FND_MESSAGE.SET_NAME('WSM','WSM_MULT_PRIMARY_PATHS_MEET');
1081: FND_MESSAGE.SET_TOKEN('WSM_SEQ_NUM',x_meet_num);

Line 1802: FROM bom_operation_networks_v

1798: p_from_seq_num NUMBER;
1799:
1800: CURSOR check_percentage_sum IS
1801: SELECT distinct (from_seq_num)
1802: FROM bom_operation_networks_v
1803: WHERE routing_sequence_id = p_routing_sequence_id
1804: ORDER BY from_seq_num ;
1805:
1806: BEGIN

Line 1816: FROM bom_operation_networks_v

1812: EXIT WHEN check_percentage_sum%NOTFOUND;
1813:
1814: SELECT SUM(planning_pct)
1815: INTO var_total_planning_pct
1816: FROM bom_operation_networks_v
1817: WHERE from_seq_num = p_from_seq_num
1818: AND transition_type IN (1, 2)
1819: AND routing_sequence_id = p_routing_sequence_id ;
1820:

Line 4293: BOM_OPERATION_NETWORKS_V to fetch standard operation id of

4289:
4290: /* bug fix:7387499
4291: ***************************************************************************
4292: created this function for bug fix 5529692 to call this in
4293: BOM_OPERATION_NETWORKS_V to fetch standard operation id of
4294: operation that is relatively effective at a particular operation
4295: sequence number and inturn fetch its op code
4296: **************************************************************************/
4297:

Line 4330: BOM_OPERATION_NETWORKS_V to fetch standard department id of

4326: end get_eff_stdop_id;
4327:
4328: /****************************************************************************************************
4329: Created this function for bug fix 5529692 to call this in
4330: BOM_OPERATION_NETWORKS_V to fetch standard department id of
4331: operation that is relatively effective at a particular operation
4332: sequence number and inturn fetch its department code
4333: ****************************************************************************************************/
4334: