APPS.WSMPUTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1200: UPDATE bom_operational_routings

1196: x_err_code OUT NOCOPY NUMBER,
1197: x_err_msg OUT NOCOPY VARCHAR2 ) IS
1198:
1199: BEGIN
1200: UPDATE bom_operational_routings
1201: SET completion_subinventory = p_completion_subinventory
1202: WHERE routing_sequence_id = p_routing_sequence_id;
1203:
1204: UPDATE bom_operational_routings

Line 1204: UPDATE bom_operational_routings

1200: UPDATE bom_operational_routings
1201: SET completion_subinventory = p_completion_subinventory
1202: WHERE routing_sequence_id = p_routing_sequence_id;
1203:
1204: UPDATE bom_operational_routings
1205: SET completion_locator_id = p_inventory_location_id
1206: WHERE routing_sequence_id = p_routing_sequence_id;
1207:
1208: EXCEPTION

Line 1496: From BOM_OPERATIONAL_ROUTINGS

1492: Into
1493: l_routing_sequence_id
1494: , l_common_routing_sequence_id
1495:
1496: From BOM_OPERATIONAL_ROUTINGS
1497:
1498: Where routing_sequence_id = l_routing_sequence_id;
1499:
1500:

Line 3926: FROM bom_operational_routings bor,

3922: if p_sequence_id_type = 'R' then
3923:
3924: SELECT count(*)
3925: INTO x_rowcount
3926: FROM bom_operational_routings bor,
3927: bom_operation_resources bres,
3928: bom_operation_sequences bos
3929: WHERE bor.routing_sequence_id = p_sequence_id
3930: AND bor.common_routing_sequence_id = bos.routing_sequence_id